Forum Discussion

Iron Contributor

Aug 14, 2020

Solved

Excel large, n=2 and n=3 return the same value.

Hi, I was trying to make a top 3 liste. Using Large function. I dont understand why the second largest, and the third largest return the same value from the list. Please see the attched workb...

excel toppliste.xlsx17 KB

excel

Formulas and Functions

Detlef_Lewin
Aug 14, 2020
Hogstad_Raadgivning
Try this:
=LARGE(SORT(UNIQUE(t_ordre[Omsetning]),,-1),1)

Detlef_Lewin

Silver Contributor

Aug 14, 2020

Hogstad_Raadgivning

Try this:

=LARGE(SORT(UNIQUE(t_ordre[Omsetning]),,-1),1)

Hogstad_Raadgivning

Iron Contributor

Aug 14, 2020

Detlef_Lewin SergeiBaklan Thank you both of you. I guessed Unique would solved it. But now I know how Large works.

Have a nice weekend.

- Geir