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