Hi I am not sure if this is a pivot table solution or an advanced filter solution. FIRST THANK YOU, THANK YOU!!!!!!!!!
OUTCOME: View each CLASS of employee (Certified, Classified Waive, etc) by PLAN with the EMPLOYEE 2 AMOUNT-not summed or counted.
WHY? I want to see that each Certified Employee or CLASS is paying the same amount for the same plan.
EXAMPLE: If I have one Certified employee paying 214.13 and one paying 399.17, for PLAN A, WHY? I will then be able to drill down and see why. On my original spreadsheet there are employee names that I deleted for this forum.
Using a pivot table doesn't work because I need it to look something like this:
PLAN A INSURANCE COMPANY
Certified Employee pays x amount
Certified Employee pays y amount
Certified Employee pays z amount
Plan B INSURANCE COMPANY
Classified Waive Employee pays x amount
Classified Waive Employee pays y amount
Classified Waive Employee pays z amount
Bookmarks