I need help with this: In cells A1:A6 I have Name of Shape In B1:B6 I have refference to another cell in form D2 in cell B1 , E3 in cell B2 , C6 in cell B3 and so on.
I need to create multiple Circular Shapes named after A1:A6 and placed into refference cells, which is in B1:B6 and loop...
I've got this sheet where I've sized the columns, rows & zoom perfectly to fit a header picture on a single screen page where you don't have to scroll to see any of the data.
Also, cells were sized specifically to overlay on top of specific parts of the header image.
I just opened the same...
Im having some issues with my code below. It works fine on majority of rows, but towards the end, it's having some issues.
What my code does is this:
- if values of cells (i,j) and cells (i+r,j), basically 1 cell and the cell below it are the same, then they merge and other columns...
Hello Excel experts,
I use a formula in Sheet2 from B10 to B100 cells.
i want to skip the blank cells in Sheet. Sheet2 protected only B10 to B100 cells are not protected.
Thanks in advance.
I am new on here and have a small problem. I want a command button to copy a range of cells and past somewhere else on the sheet. Simple enough I know, but if I have range("A1:A10") no problem, but I want range(A1:A&H1). I know this won't work, but I want the value to change to...
I am hoping someone can help.
It seems like such an easy thing to do and I just can't find the answer anywhere.
So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes"
The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
What im trying to do is average a row of numbers that represent the months. what im getting back as a result is: when i put a IFERROR(AVERAGE(A1:A5),0) FORMULA for Cells A1 thru A5 and i want my answer in CELL A7 i get one answer of the number i put in cell A1 not the adverage of that number if...
Please check the following and update how can we do that
Excel 2010 32 bit
Excel 2010 32...
I'm trying to get a number from a cell based on the criteria in 2 different cells but in the same column.
This has to be pasted in another sheet, which has got the reference number same as one of the above 2 criteria.
I'm trying to figure it out how to ensure that if some data is entered in A1 then the range B1 to E1 is to be filled in with data as well. If it is possible I would like to not allowed to save the file if the data is not entered in all required cells and display msg "please complete...
I have a large table (100x200) which is updated daily. Cells are either 0 or 1. For each column and starting from row 2 I need to count the number of continuos 0 until a cell with 1 is encountered (e.g. today cells from K2 to K13 are all 0, H14 is 1 so the result should be 12...
I am currently using this function
where B2:B262 includes figures and NAs (text).
What I would like to do is to run this function when the first 5 cells (B2:B6) in B2:B262 have at least one figure. Otherwise, return 'NA'...
i need a vlookup formula
let us suppose data is in sheet1 in column A
and there is a data in sheet2 in column F
formula will be placed in column K of sheet2
the result will be either true or false
what i need is if data of column F of sheet2 does not match with column A data ( not with...
I work in Finance and I need to send out our budget model to one of our business partners, but she can't see all the salary info we have in there.
One option is to go tab by tab (there are probably 30) and manually copy/paste values in the person-by-person salary calc, then delete the person by...
I have a calculated field formula calculating a simple division as follow:
='Cell C2' / 'Cell B2'
Some cells are returning the #DIV/0! error because some column C cells are zero. How do I write the formula to return a blank when the denominator is zero.
I have a range of cells with values inside. The values have pattern such as '123-abc'. Now I need to change the value of selection to just 123.
I currently use left function to loop over the selection. But it's very slow because I have 1000 cells.
I am working with a spreadsheet (received from an external source) where all values should have 9 characters. I want to highlight the cells where the values are fewer than 9 characters.
Is there an IF/THEN or some sort of function that I can use to highlight? It is a very large spreadsheet...
Can someone assist me in writing a formula for counting how many "I" are in a range of cells. For example I have a range of cells B11:AF12 that have different letters in it to identify the kind of Lead Source we receive. "I" represents Internet. I need to find out how many I's are in...