Hello,
I was hoping somebody could help me with a formula...
I have two columns A (where values may be entered) and B. I need a formula to enter in cells of column B that will return the following values:
If the cell A* is the first non-blank cell in the range A1:A100 then return a value "X" in column B of the same row, if cell A* is not the first non-blank cell then return a value "Y", and if the cell A* is blank, return blank ("").
Thanks in advance for your help!
Bookmarks