| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get part of field name for highest value
Hello, I have a spreadsheet which looks like the following:
AF AG AH PercentRegion1 PercentRegion2 PercentRegion3 <-- Column header 100 0 0 25 75 0 1 0 99 I would like to add another field which would be called "dominant region" and would be populated with the region number of the highest percentage i.e. 1 2 3 Any help is appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format part of text in concatenated field | Excel Worksheet Functions | |||
| Take part data from two fields and auto fill into 3rd field | Excel Worksheet Functions | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| how do I 'shadow rank' a number into a field it isn't a part of | Excel Worksheet Functions | |||
| Sum a $ amount in part of a field | Excel Discussion (Misc queries) | |||
Threaded Mode
