Reference to next non-blank cell

H

Hilvert Scheper

Dear All,
Can You Please help me on the following question:
Is there a way with a Formula to find and obtain the Text-string in the next
Non-blank cell in the adjacent column? I am making calculations from a
Pivot-Table, due to which a Varible number of Cells is Empty. I hope I am
making myself understood, here is an example:

Column A: Column B:
blank I want Cell B1 to find the next Non-blank Cell in Column A,
blank and Return the Text-string "CH4 YTG"
blank
CH4 YTG

Note: This Formula is also to be dragged down, so Listing all non-blank
cells in Column B is not an option in this case, Sorry!!

I am deeply sorry to ask this again;
as I asked this question earlier, got notified of a reply but I cannot find
my question anywhere!!! Again, my apologies for the person that answered my
question previously!!
Hilvert
 
J

Jim Cone

see your other post

Dear All,
Can You Please help me on the following question:
Is there a way with a Formula to find and obtain the Text-string in the next
Non-blank cell in the adjacent column? I am making calculations from a
Pivot-Table, due to which a Varible number of Cells is Empty. I hope I am
making myself understood, here is an example:

Column A: Column B:
blank I want Cell B1 to find the next Non-blank Cell in Column A,
blank and Return the Text-string "CH4 YTG"
blank
CH4 YTG

Note: This Formula is also to be dragged down, so Listing all non-blank
cells in Column B is not an option in this case, Sorry!!

I am deeply sorry to ask this again;
as I asked this question earlier, got notified of a reply but I cannot find
my question anywhere!!! Again, my apologies for the person that answered my
question previously!!
Hilvert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Trying to calculate next sequential number using multiple columns 1
Select Text to End of Footnote 9
Reference to next non-blank cell 5
Concat a three column range into one cell Then Next... 2
Return BLANK is cell value sought is blank 13
Return last non-blank cell in column 3
Create if partial match then copy and paste data from one cell to another 1

Top