Search : in
By :

Firmnual Help If cell is blank go to next ce

Last answer on Jan 24, 2009 10:46:14 am GMT Saul, on Sep 28, 2008 2:30:14 pm BST 
 Report this message to moderators

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

Configuration: Windows XP
Firefox 3.0.3

Best answers for « Firmnual Help If cell is blank go to next ce » in :
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
VBA macro to move to the cell 'underneath' ShowVBA macro to move to the cell 'underneath' Issue Solution Issue If you need need VBA macro to move to the cell 'underneath' the particular button that is being pressed, series of buttons down the page, each will run the same macro/do...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

YOYO, on Nov 7, 2008 5:58:32 pm GMT
  • +5

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?

   
Reply to YOYO

2

 help, on Jan 24, 2009 10:46:14 am GMT
  • +1

Give the following formula
may it solve your querry


=IF(C33="",C32,C33)

   
Reply to help
Ask your question Reply
They need your help