Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |