Hi,
I am doing a spreadsheet and i need to cross reference the highest number in one column and add the name of that row in another column for example:
=INDEX($A$4:$A$100,MATCH(E102,$J$4:$J$100,0))
E102 is the cell where the highest number is put, it has this formula:
=LARGE($J$4:$J$100,1)
i need to do this for the top 5 highest numbers but when two rows have the same number it gives the same name twice like this:
Winners Points
offelia 17
offelia 17
louis 13
raymond 10
nadine 9
Can anyone show me how to correct this? I have a feeling its gonna be an IF function but cant figure it out.
I am doing a spreadsheet and i need to cross reference the highest number in one column and add the name of that row in another column for example:
=INDEX($A$4:$A$100,MATCH(E102,$J$4:$J$100,0))
E102 is the cell where the highest number is put, it has this formula:
=LARGE($J$4:$J$100,1)
i need to do this for the top 5 highest numbers but when two rows have the same number it gives the same name twice like this:
Winners Points
offelia 17
offelia 17
louis 13
raymond 10
nadine 9
Can anyone show me how to correct this? I have a feeling its gonna be an IF function but cant figure it out.