Rank Ascending.

[MRozell]

Ok, I have a list of names and how many items each name has. I want to rank them from most to less. Done that. But when the more than one name has the same value I want them sorted ascending. I am getting them descending. I can't figure out what I am doing wrong.

Column A Name
Column B Has

Column D I Ranked
Column E shows me how many

Column G is the correct order of rank I am looking for.

[MRozell]

I figure it out, I changed.
=IFERROR(LOOKUP(2,1/(LARGE(INDEX(RANK($B$2:$B$27,$B$2:$B$27,1)*9^9+ROW($B$2:$B$27),),ROW(A1))=(INDEX(RANK($B$2:$B$27,$B$2:$B$27,1)*9^9+ROW($B$2:$B$27),))),$A$2:$A$27),"")

to

=IFERROR(LOOKUP(2,1/(SMALL(INDEX(RANK($B$2:$B$27,$B$2:$B$27,0)*9^9+ROW($B$2:$B$27),),ROW(A1))=(INDEX(RANK($B$2:$B$27,$B$2:$B$27,0)*9^9+ROW($B$2:$B$27),))),$A$2:$A$27),"")

and got what I was looking for.

[FlameRetired]

An afterthought.

Glad to hear you found solution. I case it's helpful another way could be with a helper column.

In the attached column C ... it can be anywhere or hidden for aesthetics ... this ranks the number of items.

Please Login or Register  to view this content.

Then in the Rank column J this

Please Login or Register  to view this content.

Then use your VLOOKUP formula in column K

Please Login or Register  to view this content.