Thanks Paul. The concatenation is a good idea so I can 'force' them to be
considered as one in the list. Looks like I'm forced to used helper cells
to complete the count? I don't believe you can pass an array argument into
the concatenation function?
On Tue, May 23, 2017 at 7:23 AM, Paul Schrei
There are several approaches.Using Excel functions, I would concatenate the
values;=A2&"_"&B2which would result in:SNUser1001 25 1001_251002 25
1002_251003 26 1003_261001 25 1001_251004 26 1004_26
Then you can use your functions to count unique values of column C.
You can do so
