FORMULAE

K

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
 
B

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