Generally if we use Large function to find out top 5 (any number) values from a list of duplicates it will give
67,65,65,40,40. But if you want to find out the large unique values use below mentioned formula.
Select range from B2:B6 and enter the following formula in the cell B2
=TRANSPOSE(LARGE(IF(FREQUENCY(A2:A11,A2:A11)>0,A2:A11,""),{1,2,3,4,5}))
Press Ctrl+Shift+Enter
No comments:
Post a Comment