Hi,
I just joint and this is my first post, hope people here go easy with me.
I have a mix of data (numbers, texts, blanks) in a range and I need a formula to rank the numbers according to their absolute value ignoring blanks, 0 & texts. The formula should work without a helper column and not array entered. Hope that I have explain myself clearly.
Sample data and desired results are in the attached file.
Thank you very much for the help.
I just joint and this is my first post, hope people here go easy with me.
I have a mix of data (numbers, texts, blanks) in a range and I need a formula to rank the numbers according to their absolute value ignoring blanks, 0 & texts. The formula should work without a helper column and not array entered. Hope that I have explain myself clearly.
Sample data and desired results are in the attached file.
Thank you very much for the help.