| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional maximums
I'm trying to get a function to do the equvilant of a "MaxIF" in excel.
Eg max wage of Davids My application will be for Name Date Notes Looking for last note for a person. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional maximums
Assuming data in cols A to C (Name, Date, Notes) from row2 down
then something like this in say, D2, array-entered (press CTRL+SHIFT+ENTER): =INDEX(C2:C9,MATCH(MAX(IF(A2:A9="David",B2:B9)),IF (A2:A9="David",B2:B9),0)) Adapt the ranges to suit your actual extents. Dates in B2 down are assumed real dates. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Carlos" wrote: I'm trying to get a function to do the equvilant of a "MaxIF" in excel. Eg max wage of Davids My application will be for Name Date Notes Looking for last note for a person. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Maximums in Charts | Charts and Charting in Excel | |||
| IF maximums | Excel Worksheet Functions | |||
| Select Distinct Maximums | Excel Worksheet Functions | |||
| Find Multiple Maximums | Excel Discussion (Misc queries) | |||
| setting maximums or minimums | Excel Discussion (Misc queries) | |||
Linear Mode
