Users and unique locations
Posted on 2016-08-24
I am trying to come up with a formula that will allow me to take a user’s name in one column and count all of the unique cells in another column.
The user’s names are in column P and the information I want to count is in column C. They may have looked at the same location several times in a month but I only want to know how many in the entire month are unique.
User Name = User
Location = Locs
User Name Location
Counter A 121
Counter B 121
Counter A counted 3 unique locations out of the 4 that were counted.
Counter B counted 2 unique locations out of the 4 that were counted.
I've tried a couple (both as an array and just a formula) with the same results, "0":