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 example... Col A Col B *SN User* 1001 25 1002 25 1003 26 1001 25 1004 26 this example would count 2 unique values for user 25, and 2 unique values for 26. The examples I found had criteria for both columns, here the criteria would only be applied against col B, where col A could be any value to get counted, provided it was unique when combined with its corresponding user in col B. Thanks for any help! Matt -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
