Macro to Check Dates

B

Beep Beep

I have a list of names and dates whereby the names could be listed multiple
times. What I would like to define is how many days there are between the
dates that a name appears. As an example the name Frank appears with a date
of 01/01/2010 and then appears down the list again with a date of 03/01/2010.
How many days are there between each date for Frank. Frank could be listed
more than twice, multiple times. Also there are probably 20 different names
in this list that are listed multiple times with different dates and the list
is at least a year old.
 
G

Gary Brown

OK Beep Beep,

- assume column A contains name
- assume column B contains date
- assume data starts in row 2 (Headings in row 1)
- sort by name then date ascending
- Formula in cell C1 should be...
=IF(A2=A3,B2-B3,0)
 

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

Top