| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Classification
Hello,
I am trying to classify 5 columns of scores into groups based on the dominant score in each row. for example, if column A2 has the highest score out of A2:E2, then the classification number should be 1. likewise if E2 has the highest score out of A2:E2, then the classification number should be 5 any thoughts? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Classification
Do you mean
=MAX(A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: Hello, I am trying to classify 5 columns of scores into groups based on the dominant score in each row. for example, if column A2 has the highest score out of A2:E2, then the classification number should be 1. likewise if E2 has the highest score out of A2:E2, then the classification number should be 5 any thoughts? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Classification
Do you mean
=MAX(A2:E2) Maybe more like =MATCH(MAX(A2:E2),A2:E2,0) I guess. Regards, Bernd |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Classification
sort of, but i don't need the value of the max, i need the column that the
max value is in... "Jacob Skaria" wrote: Do you mean =MAX(A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: Hello, I am trying to classify 5 columns of scores into groups based on the dominant score in each row. for example, if column A2 has the highest score out of A2:E2, then the classification number should be 1. likewise if E2 has the highest score out of A2:E2, then the classification number should be 5 any thoughts? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Classification
Try
=MATCH(MAX(A2:E2),A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: sort of, but i don't need the value of the max, i need the column that the max value is in... "Jacob Skaria" wrote: Do you mean =MAX(A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: Hello, I am trying to classify 5 columns of scores into groups based on the dominant score in each row. for example, if column A2 has the highest score out of A2:E2, then the classification number should be 1. likewise if E2 has the highest score out of A2:E2, then the classification number should be 5 any thoughts? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Classification
almost...just not consistently correct... (last column contains the formula)
3 2 3.5 3.5 1.5 4 3.5 3 3.5 4 5 5 3.5 2 4.5 3 3.5 3 3 1 4.5 2 4 3 2 10 4.5 3.5 3 5 2 1.5 3.5 4 2.5 4 "Jacob Skaria" wrote: Try =MATCH(MAX(A2:E2),A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: sort of, but i don't need the value of the max, i need the column that the max value is in... "Jacob Skaria" wrote: Do you mean =MAX(A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: Hello, I am trying to classify 5 columns of scores into groups based on the dominant score in each row. for example, if column A2 has the highest score out of A2:E2, then the classification number should be 1. likewise if E2 has the highest score out of A2:E2, then the classification number should be 5 any thoughts? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Classification
That works!!!! Thank you both so much!
"Bernd P" wrote: Do you mean =MAX(A2:E2) Maybe more like =MATCH(MAX(A2:E2),A2:E2,0) I guess. Regards, Bernd . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to auto-update a classification ONLY if it goes UP | Excel Worksheet Functions | |||
| ABC Inventory Classification | Excel Worksheet Functions | |||
| Insert Row (Event Classification) | Excel Discussion (Misc queries) | |||
| Change Font Color Based on Classification | Excel Discussion (Misc queries) | |||
| classification in column | Excel Programming | |||
Linear Mode
