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