Forum Discussion

MarkAmico's avatar
MarkAmico
Copper Contributor
Mar 07, 2023
Solved

Counting the number of unique cells in a matrix

I have a matrix (10 x 10).  I wish to compare column B rows 2 - 12 with column C rows 2 - 12, determine between the two columns, how many cells have unique data in them, and provide the numerical answer in cell C13.  The equation needs to be flexible enough so I could do the same operation but now between columns B rows 2 - 12 and column D rows 2 - 12 with the result going in D13, and so on, and so on.

Have tried SumProducts, Vlookup, and CountIF but having a difficult time how best to possibly combine multiple commands to get my results.  Any help would be greatly appreciated.

3 Replies

  • MarkAmico's avatar
    MarkAmico
    Copper Contributor
    WOW. Still wrapping my head around the formula, but I can say it does WORK! Very impressive. Thank you for both your quick response and your elegant solution! Cheers!

Resources