Dear Forum,
I am trying to find the Unique Count for 2 Column Ranges .
Col A ---- Col B
153 ------Mr A
153 ------Mr A
153 ------Mr A
153 ------Mr B
Sam------Wild
Sam------Wild
Sam------Hanks
So I need to get the answer 2 as the Value 153 is combined with just 2 different Names Mr A and Mr B..
Similarly, the First Name Sam just has 2 Differen Last Names 1. Wild and 2. Hanks.
P.S. WOuld prefer a NOn-Helper Column Approach...
Warm Regards
e4excel
Bookmarks