Forum Discussion
MarkAmico
Mar 07, 2023Copper Contributor
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
- MarkAmicoCopper ContributorWOW. 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!
- Patrick2788Silver ContributorGlad I could help. You're welcome!
- Patrick2788Silver Contributor