Combining functions

[john.marquess]

I have a spreadsheet with two functions that looks like this:

A B C D
ID * = Dupes DATE *** = 2 weeks apart
00020AS 9/04/09
00057ST 9/03/09
00072TW 11/02/09 ***
00102IP 4/10/09
00133GY 15/10/09 ***
00204GC 23/11/09
00283RL 3/09/09 ***
00330NO 30/12/09
00424AU * 8/12/09
00424AU 27/07/09
00480GL 9/05/09 ***
00506MA 24/08/09
00604MO 10/02/09 ***
00605MI 27/05/09 ***
00628LG 18/12/09
00636TN 22/11/09 ***
00680NM 8/12/09
00849MI 15/05/09
00860PA * 11/04/09
00860PA 11/04/09 ***
01020WW 19/06/09 ***
01101AU 11/09/09
01138MY 1/04/09 ***
01147PA 13/11/09 ***
01214TI 11/12/09
01235QE * 12/04/09
01235QE * 10/04/09
01235QE 10/04/09 ***
01243RB * 23/10/09
01243RB * 23/10/09
01243RB * 23/10/09


=IF(A2=A3, "*"," ")

=IF((DAYS360(C4,C5)>14),"***"," ")


The first checks column A and stars (*) duplicates
The second checks column C for dates that are two weeks apart

What I want to do is create a function that will combine both
functions such that if all unique IDs in column A are two weeks apart
in column D then a * indicators will show in both columns i.e. a * for
each unique in column A and ** if that unique ID occurred at a time
two weeks of more later than the first unique ID in B.

 

[Bob Phillips]

Do you mean

=IF(A2=A3,IF(DAYS360(C2,C3)>14,"**","*"),"")

 

[john.marquess]

Do you mean

=IF(A2=A3,IF(DAYS360(C2,C3)>14,"**","*"),"")

--

HTH

Bob

Exactly that,
many thanks.