Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max with similiar values within the range
Howdie, A1 = 4 B1 = 3 C1 = 4 D1 = 2 E1 = 3 F1 = 1 From the above I want to extract the three MAX scores, ie the answer would be 4,4,3 (preferably to be displayed in different cells)The Max number is 4. Min number is 0. Any ideas? I can find the first max, but when trying to eliminate that item from the population ie(a1-max) I get stuck because both a1-max and c1-max = 0 and thus would be eliminated from my population so my formulae cant deal with two similar scores, which unfortunately there are. Thanks guys D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max with similiar values within the range
Darin,
In cell A2 put in formula =LARGE(A1:F1,{1}) cell A3 =LARGE(A1:F1,{2}) cell A4 =LARGE(A1:F1,{3}) Regards Neil "Darin Kramer" wrote in message ... Howdie, A1 = 4 B1 = 3 C1 = 4 D1 = 2 E1 = 3 F1 = 1 From the above I want to extract the three MAX scores, ie the answer would be 4,4,3 (preferably to be displayed in different cells)The Max number is 4. Min number is 0. Any ideas? I can find the first max, but when trying to eliminate that item from the population ie(a1-max) I get stuck because both a1-max and c1-max = 0 and thus would be eliminated from my population so my formulae cant deal with two similar scores, which unfortunately there are. Thanks guys D *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max with similiar values within the range
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Similiar data on two different sheets - how to ID what is differen | Excel Worksheet Functions | |||
Something similiar to conditional formatting | Charts and Charting in Excel | |||
SUMPRODUCT or some similiar function | Excel Worksheet Functions | |||
how to combine two similiar sheet | Excel Worksheet Functions | |||
Looking for something similiar to MIN | Excel Worksheet Functions |