Selecting data by date differences

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!

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!

Please ignore post.
I had read it that you wanted to Count the transactions.

Having seen your duplicate posting in .programming, I have now read it
correctly, that you are wanting to EXTRACT transactions.

--
Regards
Roger Govier

"Roger Govier" roger@technology4unospamdotcodotuk wrote in message
...
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!

Use Excel 2003 List
or Excel 2007 Table.
Helper column needed:
http://www.savefile.com/files/1751485