=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
--
Wag more, bark less


"Phxlatinoboi®" wrote:

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.