Hi, Hopefully the name is pretty self explanatory...
I have Column C which will be basically empty apart from a 2 entries... 1 negative, and 1 positive number.
I want a formula to find the postive (greater than 0), and return the name of the data in column A... and same for the negative.
Any ideas?
I have Column C which will be basically empty apart from a 2 entries... 1 negative, and 1 positive number.
I want a formula to find the postive (greater than 0), and return the name of the data in column A... and same for the negative.
Any ideas?