Selecting data by date differences

  • Thread starter Thread starter saylur
  • Start date Start date
S

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!
 
Hi

Maybe something like
=SUMPRODUCT(($A$2:$A$6=A2)*($C$2:$C$6>=C2-15)*($C$2:$C$6<=C2+15))
 
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.
 
Back
Top