Good Morning,
I am in need of direction in building a formula to count the number of unique values in column A corresponding with the value in Column B.
Column B contains a list of values identifying a specific person. Column A contains a list of locations they have been. I need column C to list how many unique locations they have been.
In the picture example below for instance. Column C for Identifier "9994" would be 2.
1-16-2014 10-33-51 AM.jpg
Thank you in advance.
Try this array formula**
=SUM(IF(FREQUENCY(IF(B$2:B$18=B2,MATCH(A$2:A$18,A$2:A$18,0)),ROW(A$2:A$18)-ROW(A$2)+1),1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That was perfect! Thank you sir!
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks