| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To choose the best field in EXCEL
Dear all
I have the following set of data in which I want to find the best fields (ie: best grades). Is there a function in which I can choose the best 3 subjects? Many Thanks! Eg: Subject 1 Subject 2 Subject 3 Subject 4 John A2 B4 A1 D7 Peter B4 C6 C6 E8 tONY 34 55 68 34 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To choose the best field in EXCEL
First you should specify the order of grades from best to worst, (maybe you
mean this order, but we cannot be su A1,A2,...,B1,B2,..., but where is the place for 34,55,... in the sequence?) Regards, Stefi €˛Jean€¯ ezt Ć*rta: Dear all I have the following set of data in which I want to find the best fields (ie: best grades). Is there a function in which I can choose the best 3 subjects? Many Thanks! Eg: Subject 1 Subject 2 Subject 3 Subject 4 John A2 B4 A1 D7 Peter B4 C6 C6 E8 tONY 34 55 68 34 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get excel to choose the second to last # in a series? | Excel Discussion (Misc queries) | |||
| Can I choose more than one item in the page field area? | Excel Discussion (Misc queries) | |||
| Set up macro in Excel to choose active row? | Excel Worksheet Functions | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
| in excel, how do I choose a column and add 20% | Excel Worksheet Functions | |||
Linear Mode
