RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 202
- Office Version
- 365
- Platform
- Windows
I have a tricky one and cannot seem to find anything searching the web related and im not sure how to phrase it. I am currently working with this formula...
=IFERROR(ROWS(UNIQUE(FILTER(IHC!$A$3:$A$40000,(IHC!$N$3:$N$40000=Summary!B51)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")
which basically says to count unique rows if employee name matches, status is "processing" or "open" and it did not come from "Hemepath". One factor we did not take into account is the dates. Somehow i need to add a criteria that says if the dates in column O are the same then only count the rows for that date 1x, however, if the dates are different then count it 2x or 3x based on how many different dates there are.
In this example, AB23455 should be counted 2x for Mel because she handled the code on 7/12 then again on 7/13.
hopefully this makes sense.
A - J - N- O
=IFERROR(ROWS(UNIQUE(FILTER(IHC!$A$3:$A$40000,(IHC!$N$3:$N$40000=Summary!B51)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")
which basically says to count unique rows if employee name matches, status is "processing" or "open" and it did not come from "Hemepath". One factor we did not take into account is the dates. Somehow i need to add a criteria that says if the dates in column O are the same then only count the rows for that date 1x, however, if the dates are different then count it 2x or 3x based on how many different dates there are.
In this example, AB23455 should be counted 2x for Mel because she handled the code on 7/12 then again on 7/13.
hopefully this makes sense.
A - J - N- O
Code | Status | Last Changed | Last Changed Date |
| |||
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | Mel | 7/12/2023 17:57 |
AB23455 | Processing | VV | 7/13/2023 12:28 |
AB23455 | Open | CD | 7/13/2023 16:04 |
AB23455 | Processing | Mel | 7/13/2023 16:13 |
AB23455 | Open | CD | 7/13/2023 18:24 |
AB23455 | Processing | CD | 7/13/2023 18:30 |
AB23455 | Processing | CD | 7/13/2023 18:38 |
AB23455 | Processing | CD | 7/13/2023 18:42 |