Firmnual Help If cell is blank go to next ce

Closed
Saul - Sep 28, 2008 at 09:30 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Aug 12, 2011 at 02:13 AM
Hello,
EXCEL FORMULA
If cell is not blank automatically look go to next cell (across) and if the cell has text in it the show the text ?
I have 35 colums some have info (dates) and some do not I am trying to show the last intry in the colum at the end ? Hope this makes sense and if someone could help please ?

Thanks

Saul
Tanzania

4 responses

Well I have a similar question if any of you excel gurus know.

I am looking to have (example) cell b34 return what is in cell c33, the cell next to and one up from it. But if cell c33 is blank, then I want it to return cell c32, and if cell c32 is blank then cell c31 and so on. I want the entire B column to return the same formula.

Does anyone know how this can be accomplished?
9
give the following formula
may it solve your querry


=IF(C33="",C32,C33)
0
I know this was posted a few years ago but I have the exact same question. Saul, did you get an answer? Help, I dont think that would work for the entire column B.

I have been looking for a few days in different forums and this is the closest I have come to finding an answer!

I'd appreciate an answer that works! Thanks
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 11, 2011 at 06:08 PM
seems like you want to know what is the last entered value on a row. For that, I would think you need to write a custom formula, that will take in the row as parameter and return to you the last value used on that row
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Aug 12, 2011 at 02:13 AM
Hi Trina,

Can you explain what exactly you required with some sort of data, this will help us to understand your problem and help you accordingly.

Regards,
Rahul. :)
0