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.

=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.

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.