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)

--
Biff
Microsoft Excel MVP


"Phxlatinoboi®" wrote in message
...
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.