I'm using this array formula to count the number of Unique Items in Column B for each Unique Item in Column A
I need to expand this formula so that it now counts the number of unique Colours in column C for each unique Animal in column B with a unique letter in column A. So when the entries are changed in cells J14 and J15 it gives the answer in cell J16. Please see sample attached.![]()
Please Login or Register to view this content.
Many thanks
Bookmarks