So I have a colum of data 100 lines. Some of the cells are merged together in the collum some are not. I need a formula to returtn the value of the cell to the left in the cell to the right. If the cell to the left is merged. I need the merged value in all the cells to the right of the merged cells.
See example.
In B3 put this formula and drag down
=IF(A3=0,B2,A3)
That only works if two cells are merged. Some sales may have 9 merged cells other could have two. I need a formula that works for no matter how many merged cells there are the the left. Also there are instances where there are two sets of merged cells next to each other. So if you pull the value from above for the 1st group when you hit the next set of merged without a break it will return the value for the first set not the second. Also I need to account that some sales are merged and blank. If a cell is merged and blank it need to stay blank on the colum on the right.
Here is an example with your formula.
Last edited by frisbie17; 09-10-2012 at 09:33 AM.
works fine for me, try it out.
Its B2 in the middle, not A2
Edited. If a merged cell is blank it does not work. See my edited post above with pic. Sorry I was editing while you posted this.
oh okay
use this one
=IF(ISBLANK(A3), " ", IF(A3=0, B2, A3))
I jumped the gun, gimme a second
That does not quite work either. Here is what that returns.
Let me know. It is not quite simple. I struggled with pulling the cell above and a variety of nested ifs. Problem comes up when blank merged cells followed filled merged cells. Also the merged cells could be 2 cells or 10. or anything inbetween.
Hmm yeah im not sure either. You might need to transfer this post to the vba forum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks