Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi!
I'm currently using the LARGE function to return the top 5 numbers in a set of cells. Now the problem is that the formula sometimes returns the same value. Example A 20 55 85 75 15 65 75 75 35 95 On the sample above, below formula returns the top value as: =LARGE(a1:a10,{1}) ... {2}, {3} and so on.. top 1 = 95 top 2 = 85 top 3 = 75 top 4 =75 top 5 =75 What i want to happen is for the formula not to return the same value if it's already on the other top numbers. Is there any way to do that? Pls help, thanks so much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
SUMIF(AND) FUNCTION | Excel Worksheet Functions |