wizardmagu
Board Regular
- Joined
- Dec 27, 2012
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
Based on data in many cells I will be designating the columns into the following categories:
*Type 1
*Type 2
*Type 3
*Type 4
A single row in excel will have multiple columns of various designations of the above types and I want to pick designate the entire row to the lowest Type from list above.
For example if Row 1 has:
A B C D
Row 1 Type 1 Type 1 Type 3 Type 2 Then the final output of this row of data will be Type 3 (in column/row E1) because that is the lowest type available from the 4 types available.
I am trying to come up with a way to give a "Final" designation. Hope this explanation makes sense.
*Type 1
*Type 2
*Type 3
*Type 4
A single row in excel will have multiple columns of various designations of the above types and I want to pick designate the entire row to the lowest Type from list above.
For example if Row 1 has:
A B C D
Row 1 Type 1 Type 1 Type 3 Type 2 Then the final output of this row of data will be Type 3 (in column/row E1) because that is the lowest type available from the 4 types available.
I am trying to come up with a way to give a "Final" designation. Hope this explanation makes sense.