| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value based on criteria
I have three columns. One is a list of job titles, one is their hourly labor
rates and one is the state in which they work. There may be several labor rates listed for a given job title and there may be duplicates. I want a formula that gives the max value for a given job title and state. I know how to do it using a pivot but don't want to use one since I want row titles for every row. I tried using a sumproduct and max but that didn't work...any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum value based on criteria
One way (array entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=MAX((A1:A100="Job Title")*(B1:B100="State")*C1:C100) In article , Steve wrote: I have three columns. One is a list of job titles, one is their hourly labor rates and one is the state in which they work. There may be several labor rates listed for a given job title and there may be duplicates. I want a formula that gives the max value for a given job title and state. I know how to do it using a pivot but don't want to use one since I want row titles for every row. I tried using a sumproduct and max but that didn't work...any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a maximum value that matches criteria. VLOOKUP? | Excel Worksheet Functions | |||
| Looking up maximum value based on another value | Excel Worksheet Functions | |||
| Conditional formatting data based on the maximum in the set | Excel Worksheet Functions | |||
| Minimum and Maximum with Complex Criteria | Excel Discussion (Misc queries) | |||
| Need help looking up value based on criteria | Excel Worksheet Functions | |||
Linear Mode
