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
Hello all,
I have a bit of a variation from the count unique values with 2 criteria...
in this case I have two columns: the first is a list of serial numbers that
does contain duplicates and the second column is the user number that has
used that serial number (also contains duplicates).
For e