Hi,
I am new to VBA trying count unique comma separated names from a range of cells,
I have range D6 to J75, each cell contains names separated by comma and space, and some times repeated for example D6 as Joes, Tony, Samuel, Joes, and E8 as Adrian, Sam, Prakash, Tony, After the macro: It should get count 6 in G8,
thanks
rao