Forum Discussion
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 workbok for an example.
Best Regards
- Geir
12 Replies
Sorting would also return a suitable list.
= INDEX( SORTBY(t_ordre, t_ordre[Omsetning],-1), Nummer, {4,1} )where 'Nummer' refers to
= SEQUENCE(12)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
Detlef_Lewin yes, that's better solution, I just mapped pre-DA approach
My preference is to give up non-DA development altogether.
The last resort is to charge the client an extra grand and provide a computer and 365 license to go with the solution workbook!
