Hi guys, I have a problem in counting number of unique rows based on conditions of other columns.
If you see the image below, this is just an example of the actual table which contains a few hundred of rows. How could I count the number of unique names which have Color blue and size 1? The answer should be 2, but how could I automate the process with formula in excel? Thank you so much for you help!
Attachment 618418
Name Color Size Alice Blue 1 Alice Blue 1 Bob Yellow 2 Bob Yellow 2 Bob Yellow 2 Charles Red 3 Charles Red 3 David Blue 1 David Blue 1 Edward Blue 3 Ford Red 1 Ford Red 1
Bookmarks