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.

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)

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Beep Beep" wrote:

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.