I am looking for a formula that will count unique occurrences that start with W81UTH, ignoring duplicates and blank cells.
Also looking for a formula that will count unique occurrences that does NOT start with W81UTH, ignoring duplicates and blank cells.
I want to achieve the desired results below in cells D3 and D4.
Also looking for a formula that will count unique occurrences that does NOT start with W81UTH, ignoring duplicates and blank cells.
I want to achieve the desired results below in cells D3 and D4.