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 workb...
Sorting would also return a suitable list.
= INDEX(
SORTBY(t_ordre, t_ordre[Omsetning],-1),
Nummer,
{4,1}
)where 'Nummer' refers to
= SEQUENCE(12)