| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Selecting data by date differences
Hi
Maybe something like =SUMPRODUCT(($A$2:$A$6=A2)*($C$2:$C$6=C2-15)*($C$2:$C$6<=C2+15)) -- Regards Roger Govier "saylur" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Selecting data by date differences
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. -- Regards Roger Govier "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Maybe something like =SUMPRODUCT(($A$2:$A$6=A2)*($C$2:$C$6=C2-15)*($C$2:$C$6<=C2+15)) -- Regards Roger Govier "saylur" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Selecting data by date differences
Use Excel 2003 List
or Excel 2007 Table. Helper column needed: http://www.savefile.com/files/1751485 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
