Ranking Duplicates and not counting 0's

[gilpin004]

Hello,

I have been trying to figure out how to recount/reorder data. After, reading and reading it appears the ranking is the best way to go about what I am trying to do.

With that said, how can I Rank the attached spreadsheet. I

Column A is the data to 'rank', Column D is the results, and I left column B for a formula that I have spent loads of amount of time figuring out.

I said 0's in the title but I meant to say the work "all"

Thanks in advance for your help!

[daddylonglegs]

Try this array formula in row 2

=IF(ISNUMBER(A2),SUM(IF(FREQUENCY(IF(ISNUMBER(A$2:A$27),IF(A$2:A$27<A2,A$2:A$27)),A$2:A$27),1))+1,A2)

confirm with CTRL+SHIFT+ENTER and copy down

That gives me the same results as you showed in your "expected results" column

see attached

[gilpin004]

That works! Thank you so much!! You're life saver!