Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modified /advance "Max function "may help!!
Dear All,
I try to use max function to get the maximum value from data as follows: Col A Col B Col C Row1 Name Class Mark Row2 AA 1 100 Row3 BB 2 55 Row4 CC 1 20 Row5 DD 3 45 Row6 EE 2 95 Row7 FF 3 87 Row8 GG 1 55 Row9 HH 3 89 Row10 II 2 85 Row11 JJ 1 45 Summary/Result: Class Maximum Mark 1 100===Is there any idea that I could use "modified Max functions " to get the max mark for each class? (without any sort/re-sort of sequence of row data above) 2 95 3 89 Many thanks for any advise and suggestions Best Regards PA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Sum Function sometimes displays incorrect answer | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |