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