extracting earliest date (age) from list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

key coulm 2
How do I add dashes to a string? 3
filtering 4
#REF! error when deleting rows 2
Highlighting reaccuring info in a spreadsheet 2
Transpose and Fill? 7
Help me parsing Data and Organizing 1
suppressing repeated data 3

Back
Top