FORMULAE

[KATE]

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

[Bob Phillips]

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" <KATE@discussions.microsoft.com> wrote in message
news:906FEAC1-D659-42AE-B61C-98999A387F7D@microsoft.com...
> 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