Formula Assistance

P

Phxlatinoboi®

I need help with an "if" formula.

Agent# Date Amount
12345 7/17/2008
12345 7/17/2008 6.54
12345 7/17/2008 0.52
12345 7/28/2008 0.12

I need the formula to tell me if the agent has duplicate date entries.
 
B

Brad

=SUMPRODUCT(--($E$4:$E$15=E4),--($F$4:$F$15=F4))
Assumining that the agent number are in e4-e15
and the dates are in f4-f15
This will get you what you want

if you put this formula in G4 - you would have to copy down to g15
 
T

T. Valko

Try this array formula**. Assuming there are no empty date cells.

=IF(COUNTIF(A2:A5,A2)=COUNT(1/FREQUENCY(IF(A2:A5=A2,B2:B5),B2:B5)),"no
dupes","dupes")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 
Top