Hi,
I am trying to use a formula which first creates a unique list based on the names in column C and then use a simple countif formula to count the number of occurrences.
I have it working for the list however the problem is when I have blank rows.
On my attached file, cells W38:X61 is where I have the list. Can anyone see what I am doing wrong? I wouldn’t want the cells in yellow to be included as the list is to be graphed.
Paul
Bookmarks