hatahetahmad
New Member
- Joined
- Jan 8, 2016
- Messages
- 31
Hello Everyone,
I everyday get large (over 10,000 rows) data in one table that i want to consolidate patient by date
Names in : patient
Consolidated column : billed, approved, collected, adjusted
Filtered or Summed by : servdate
Like :
Patient | servdate | billed | approved | collected | adjusted
SURNAME, FIRST_NAME | 6/24/2016 | 885.33 | 295.11 | 289.21 | 590.22
\\ I Don't Mind VBA Solution or advanced filter but please I Need A Solution
{confidential data removed - per OP's request}
I everyday get large (over 10,000 rows) data in one table that i want to consolidate patient by date
Names in : patient
Consolidated column : billed, approved, collected, adjusted
Filtered or Summed by : servdate
Like :
Patient | servdate | billed | approved | collected | adjusted
SURNAME, FIRST_NAME | 6/24/2016 | 885.33 | 295.11 | 289.21 | 590.22
\\ I Don't Mind VBA Solution or advanced filter but please I Need A Solution
{confidential data removed - per OP's request}
Last edited by a moderator: