Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple criteria
Hello,
I have the following spreadsheet Last Name First Name ID Date Goal Doe Jane 123 8/7/08 B Doe John 124 8/9/08 D Some rows have the same ID. I would like my results to list unique id's. If there is the same id in two rows, I would like it to display the row with the most recent date. If there is the same id in two rows with the same id and the same date, i would like it to show the row with the highest goal (A being the highest and so on). Thank you for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |