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 *** |
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 *** |
Max with similiar values within the range
|
All times are GMT +1. The time now is 04:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com