View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
saylur saylur is offline
external usenet poster
 
Posts: 8
Default 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!