Hi

Maybe something like
=SUMPRODUCT(($A$2:$A$6=A2)*($C$2:$C$6=C2-15)*($C$2:$C$6<=C2+15))

--
Regards
Roger Govier

"saylur" wrote in message
...
I have a large amount of data which includes account numbers and
'transactions.' Each account has more than one transaction, and each
transaction has an associated date. I.e.:

Account Transaction Date
123 1 1/1/08
123 2 1/31/08
234 1 1/15/08
234 2 1/16/08
234 3 1/17/08

OK; How do I create a report which extracts all account data for each
account with transactions less than a certain number of days apart (like
30
days apart)?

My macro and formula skills are limited.

THanks for any help!