Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date and time differences revisited | Excel Discussion (Misc queries) | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Selecting date specific data from different spreadsheets | Excel Discussion (Misc queries) | |||
Selecting data within a date range | Excel Worksheet Functions | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) |