Same value but different name

[fadilahisnin]

Dear all,


I have this situation whereby i have a sets of data with their individual name. But that sets of data( numbers) are repeating (nontheless, got their individual unique name). After i choose the top 10 (using largest function) of highest value out of 200 data (numbers), the index function that i used to match the name with the data will keep on repeating the first name of the same number.


For example :

(TOP 10 DATA WITH THEIR UNIQUE NAME - sequence that i want)

A 7

B 7

C 4

D 4

E 3

F 3

G 2

H 2

I 2

J 2


(RESULTS I GET)


A 7

A 7

C 4

C 4

E 3

E 3

and so on.


How to resolve this????


TQ in advance

 

[Hui]

Fadilahisnin


Firstly, Welcome to the Chandoo.org forums.


I'm slightly confused as to your requirements


Can you upload a file with a sample of your data , what you get and what you want highlighted

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[fadilahisnin]

Hi Hui,


Below is the link to my example data :


https://hotfile.com/dl/161259747/66d3e9f/Example_of_Data__result_I_get_and_result_that_I_want.xlsx.html

 

[NARAYANK991]

Hi ,


With specific reference to your worksheet , try this formula :


=INDEX($D$4:$I$4,SMALL(IF($D$5:$I$5=D20,COLUMN($D$4:$I$4)-COLUMN($D$4)+1),COUNTIF($D$20:D20,D20)))


This is an array formula , to be entered using CTRL SHIFT ENTER.


Narayan