VBE313
Well-known Member
- Joined
- Mar 22, 2019
- Messages
- 686
- Office Version
- 365
- Platform
- Windows
How can I count Operations Complete in this scenario? I need to get the unique Completed Operation Sequences per Name (Column H). I don't know what formula I could use in H2. Does anyone have any ideas how I could count unique values that only have "Completed" in the 'Completed?' column? The formulas in F2,F3 and G2 are in a table below the data table.
Name | Qty | Operation Sequence | Completed? | Completed Qty | First of Name? | Total Operations |
Ethan | 40 | 5 | Completed | 20 | Yes | 4 |
Ethan | 40 | 5 | Completed | 10 | ||
Ethan | 40 | 5 | Completed | 5 | ||
Ethan | 40 | 5 | Completed | 5 | ||
Ethan | 40 | 10 | Completed | 10 | ||
Ethan | 40 | 10 | Completed | 10 | ||
Ethan | 40 | 10 | Completed | 20 | ||
Ethan | 40 | 15 | Completed | 8 | ||
Ethan | 40 | 15 | Completed | 8 | ||
Ethan | 40 | 15 | Completed | 8 | ||
Ethan | 40 | 15 | Completed | 8 | ||
Ethan | 40 | 15 | Completed | 8 | ||
Ethan | 40 | 20 | Completed | 20 | ||
Ethan | 40 | 20 | Completed | 20 | ||
Emily | 30 | 5 | Completed | 10 | Yes | 6 |
Emily | 30 | 5 | Completed | 5 | ||
Emily | 30 | 5 | Completed | 5 | ||
Emily | 30 | 5 | Completed | 10 | ||
Emily | 30 | 10 | ||||
Emily | 30 | 20 | ||||
Emily | 30 | 30 | ||||
Emily | 30 | 40 | ||||
Emily | 30 | 50 |
Formula in G2 | =IF([@[First of Name?]]="Yes",COUNTA(UNIQUE(FILTER([Operation Sequence],[Name]=[@Name]))),"") |
Formula in F2 | =IF(COUNTIF(A2:$A$2,A2)=1,"Yes","") |
Formula in F3 | =IF(COUNTIF(A$2:$A3,A3)=1,"Yes","") |