Backwards Searching Using a Formula
Hi
I am seaerching for a formula that will reverse search a single column array for the first non blank cell and return the number in the cell to the right of that value.
For example:
A10 contains "Object Number:", B10 contains "2456"
Current Active Cell is A20
Search from A20 backwards to A10 and then when it finds the cell is non-blank then return the value in B10.
Any help would be appreciated.
Tony
|