Selecting data by date differences

[saylur]

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!

 

[Roger Govier]

Hi

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

 

[Roger Govier]

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.

 

[Herbert Seidenberg]

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