View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lorna_Jane Lorna_Jane is offline
external usenet poster
 
Posts: 1
Default 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