Hi All,
Im having a little trouble with counting job numbers by a single date. The current formula I am using works great when I want to count job numbers that dont appear on more then one date, but if the job number appears on more then one date I will get inaccurate data because the value on the formula will only appear on the first instance of the job number.
In the attached example, Job 3 appears on both 1-Oct and 2-Oct. When I got to my Pivot Slicers I filter by date, then Job Number. If I select all dates Job 3 will appear, but if I select 2-Oct the Job will not appear because the formulas have already counted it on 1-Oct.
Do I need to add an additional column with a formula to count the Job number respstive to each date, or am I just structuring this incorrectly? Im attempting to keep this as simple as possible because there is a massive amount of formulas in the actual workbook and I want to keep it functioning as fast as possible.
Thanks!
Bookmarks