chameleon_crp
New Member
- Joined
- Apr 7, 2013
- Messages
- 5
Is there a formula that will tell me what was the last text in a range that has blank cells? All the cells have formulas and the blank cells have formulas with the outcome of "".
Example:
COLUMN A COLUMN B
ROW 1 A
ROW 2 X
ROW 3 X
ROW 4
ROW 5
ROW 6 A
The formula i am looking for would look up the range A1:B6 and look up the last text before the A in column B which should be an X.
Example:
COLUMN A COLUMN B
ROW 1 A
ROW 2 X
ROW 3 X
ROW 4
ROW 5
ROW 6 A
The formula i am looking for would look up the range A1:B6 and look up the last text before the A in column B which should be an X.