I need formulas that will count unique occurrences, certain words while Ignoring blank cells and duplicates. I am trying to achieve the results in cells D8 and D9.
In this case, I need to count occurrences that starts with W81UTH excluding duplicates and blank cells. I also need to count ALL MIGOs in the same formula.
The other formula I need is similar, count occurrences that does not start with W81UTH, excluding duplicates, blanks, and MIGOs. This formula needs to count ALL CUST P/U as well.
If this sounds confusing I will try to re-word it. I can do it using 2 formulas, I am just wondering if there is a single formula for what I am trying to do.
In this case, I need to count occurrences that starts with W81UTH excluding duplicates and blank cells. I also need to count ALL MIGOs in the same formula.
The other formula I need is similar, count occurrences that does not start with W81UTH, excluding duplicates, blanks, and MIGOs. This formula needs to count ALL CUST P/U as well.
If this sounds confusing I will try to re-word it. I can do it using 2 formulas, I am just wondering if there is a single formula for what I am trying to do.
