"Large" Formula with Duplicate values

[Neranjan]

Dear all,

I have a outlet list with sales volumes. But sales volumes with duplicate volumes with separate outlets (My original list is a big list, I attached a small sample list)
So I want get a list Outlet list based on "sales volume" as a descending order. Pls see the attachment.

Thanks

Neranjan

[avk]

Hello Neranjan : Have a good day.
Please look attach file.
In this file i have define rank (in both table)column base on values.
In outlet name (Second Table use index match formula)

[JohnTopley]

In D3 Rank your sales volumes: you can "hide" this column elsewhere on your sheet

=RANK(C3,$C$3:$C$15,0)+COUNTIF($C3:C$3,C3)-1

In E3 Ranked Sales

=INDEX($C$3:$C$15,MATCH(ROWS($1:1),$D$3:$D$15,0))

in F3 Outlets

=INDEX($B$3:$B$15,MATCH(ROWS($1:1),$D$3:$D$15,0))

[Tony Valko]

This array formula** entered in G4 and copied down:

=INDEX(B:B,SMALL(IF(C$3:C$15=F4,ROW(C$3:C$15)),COUNTIF(F$4:F4,F4)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.