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
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Aug 12, 2011 at 02:13 AM
Related:
- Firmnual Help If cell is blank go to next ce
- If cell contains date then return value ✓ - Office Software Forum
- Ce-42288-4 - PS3 & PS4 Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
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?
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?
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 11, 2011 at 06:08 PM
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
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Aug 12, 2011 at 02:13 AM
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. :)
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. :)
