Problem with LARGE

[Heiervang]

Hey all !

http://img15.hostingpics.net/pics/819754Capturede769cran20160530a768124859.png

Here’s my problem. I’ve got a list of name and numbers (columns E, F and G), that needs to be sorted according to the numbers in column E (biggest first, smallest last). Columns A, B and C is the sorted list.

It’s as I want it, except that, as you can see, “April” is nowhere to be found in the sorted list.

This is the function I used in column A : =LARGE(E1:E4;1)
This is the function I used in column B and C : =IFERROR(VLOOKUP(LARGE(E1:E4;1);E1:F4;2;0))
I adjust them for each row (I change the “1” in the LARGE function to 2, 3 and 4).

I can’t get the formula for columns B and C to work correctly when there’s two equal numbers in column E. LARGE doesn’t seem to be able to make a difference between them…

Any ideas ?

Thanks

[erAck]

Why don’t you just select E1:E4, invoke Data → Sort, sort on column E descending, and under Options enable “Copy sort results to:” and enter A1 as destination (for this example)?

Of course LARGE does not distinguish between equal numbers, how should it? Anyway, VLOOKUP returns an error if it is to find an exact match where two equal values exist.