Using INDEX function to get the top 10

[all4excel]

I have a database of three columns.
Col A Col B Col C
Sr.No. Name of the Store Sales Figures
1 Walmart $199
2 Shopmart $299
3 Toys R Us $1990
4 The Buyers $1989
5 Shoppers Stop $2360
6 Shopper's paradise $199

Now this is the original data

I want the data to get sorted based on the sales figure automatically and PROGRAMATICALLY not using the SORT function...

I am using the formula

[ = INDEX(B:C,MATCH(LARGE(C:C,ROW()-1),C:C,0),1) ]

This is working fine however i want to take care of duplicate data values like

Sr.No. Name of the Store Sales Figures
1 Walmart $199
6 Shopper's paradise $199..

I have seen some code in this wonderful forum which takes care of that..

Which introduces a miniscule difference by using ^ i.e. raise to soomething..

Thanx in anticipation

[daddylonglegs]

Yes, you can do it that way but I'd suggest a slightly different approach using a "helper" column to give each store a unique rank and then using that rank as a "key" to produce a sorted table, see attached

Note: the formula in B13 can simply be copied across and down as necessary

[vane0326]

If you want to list the largest values in a alphabetical order that account for duplicates then try...

Assuming your names are in column B and the values are in column C

Input forumla in cell E2 and copy down.

Please Login or Register  to view this content.

The formula is an-array must hold down:

Ctrl,Shift,Enter


If you would like a non-array aprroach they try...

Input formula in cell E2 and copy down.

Please Login or Register  to view this content.

[all4excel]

Thanx for the help DADDYLONGLEGS and vane...
I have attached the file which i was able to recover...

Both your codes worked however ur file didnt open...

[JLRO]

Hi Daddylonglegs and Vane,

Using the "Large sort.xls file" as the example, if there were "errors", such as "#Value!" or alpha information in column C, how could the formula be changed to still work?

Thank you in advance.