Hi all,
I'm looking for some help with a formula that will do the following (see screenshot): for every different "Person x" that appears in the Names column (multi select dropdown), count the total number of unique items that appear on rows wherever Person x is listed. Items are in another multi select dropdown column.
The intended result is shown in the last column (# different items) of the screenshot below. Here the number has been calculated and entered manually for illustration. Having searched the community forum for similar questions and tried a range of a formulas and functions in combination I haven't made any progress, so any suggestions would be greatly appreciated!
Many thanks,
David