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 ans...
- Mar 07, 2023
MarkAmico
Mar 07, 2023Copper 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!
Patrick2788
Mar 07, 2023Silver Contributor
Glad I could help. You're welcome!