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...
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!
Look, with millions of users who don't want or can't afford to buy new computers and licenses we always have to find some compromise. Excel is the behemoth in software world with it's own rules of behaviour.
