luckeyjune
New Member
- Joined
- Jun 28, 2021
- Messages
- 12
- Office Version
- 2016
- Platform
- Windows
Hi, after searching for days I figure I'll ask for help with this. I'm trying to get a 1,0 result to assist with summing in a pivot. The dataset is too big for an array formula.
Basically I am trying to obtain the metric work orders per person per day. I figure if I'm able to return a 1 for each Employee ID#, but only 1 for the unique day worked. There are duplicates of the ID#s and dates for each employee since there are many work types, statuses, etc. Here's an example of what I am trying to achieve. So if I were to SUM in a pivot ID 5046 for 10/21/2021 it would only return 1. I don't know how something so seemingly simple has stumped me so terribly! Thanks : )
Basically I am trying to obtain the metric work orders per person per day. I figure if I'm able to return a 1 for each Employee ID#, but only 1 for the unique day worked. There are duplicates of the ID#s and dates for each employee since there are many work types, statuses, etc. Here's an example of what I am trying to achieve. So if I were to SUM in a pivot ID 5046 for 10/21/2021 it would only return 1. I don't know how something so seemingly simple has stumped me so terribly! Thanks : )