| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting earliest date (age) from list
I have a large list that has the following:
CLIENT DOB EVENT DATE AA 111 111 AA 111 222 BB 222 111 CC 333 111 CC 333 222 What I want to do is to have separate list that gives me the client name and the earliest event date for that client. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extracting earliest date (age) from list
Hi,
Maybe something like this: =DATEDIF(INDEX(B1:B100,MATCH("AA",A1:A100,0)),MIN( IF(A1:A100="AA",C1:C100)),"y") enter using Ctrl+Shift+Enter will return the age a person had at the earliest event date. HTH Jean-Guy "Dave" wrote: I have a large list that has the following: CLIENT DOB EVENT DATE AA 111 111 AA 111 222 BB 222 111 CC 333 111 CC 333 222 What I want to do is to have separate list that gives me the client name and the earliest event date for that client. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
| Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
| How do I get the most current date from a list of dates? | Excel Discussion (Misc queries) | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| Data in list w/same A:B move to column | Excel Worksheet Functions | |||
Linear Mode
