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
row 1
row 2 X
row 3 X
row 4
row 5
row 6
column b
row 1 A
row 2
row 3
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 from column A.
Example:
Column A
row 1
row 2 X
row 3 X
row 4
row 5
row 6
column b
row 1 A
row 2
row 3
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 from column A.