FORMULAE
 

I NEED TO ENTER A FORMULAE TO COUNT THE INTERVALS BETWEEN DATES. COLUMN A
CONTAINS NAMES. COLUMN B CONTAINS DATES. IF A NAME IS REPEATED I NEED TO
WORK OUT THE INTERVAL BETWEEN THE TWO DATES

FORMULAE
 

In C2:
=IF(ISNUMBER(MATCH(A2,$A$1:A1,0)),B2-INDEX(B:B,MATCH(A2,$A$1:A1,0)),"")

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KATE" wrote in message
...
I NEED TO ENTER A FORMULAE TO COUNT THE INTERVALS BETWEEN DATES. COLUMN A
CONTAINS NAMES. COLUMN B CONTAINS DATES. IF A NAME IS REPEATED I NEED TO
WORK OUT THE INTERVAL BETWEEN THE TWO DATES