I am looking to get the total per check date for vision and for dental on the "June deduction tab" and then match it to the invoice date for dental and vision on the "June bill" worksheet. example: client ID 5 on the "June Deduction" for 6/7 the vision total is 104.28 and dental total is 435.97 needs to go next to the total the Dental and Vision for the 6/7 check date and then needs a difference column. hope this explains it. still new to excelDropbox
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula or pivot table needed
- Thread starter joeangry
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,536
- Office Version
- 365
- Platform
- Windows
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Formula needed
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Formula needed
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Upvote
0
Similar threads
- Question
- Question
