Hi,
we have cell content on three columns.
for ex.
A9, A10 & A11
If the cell is NOT BLANK on A9...& if it blank on A10 & A11 - Then I should get a value "1st" on A12
If the cell is NOT BLANK on A9 & A10 & if it is blank on A11 - Then I should get a value "2nd" on A12
If the cell is NOT BLANK on A9 & A10, A11 - Then I should get a value "3rd" on A12
Can you please help me guys ? Thank you
shadmani
Bookmarks