Firmnual Help If cell is blank go to next ce

Closed
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
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 replies

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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

give the following formula
may it solve your querry


=IF(C33="",C32,C33)
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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. :)