Hi everyone
quick question, is there a simple way to count the number of unique cells in a column? the COUNT function won't work because the cells aren't numbers, they're like this: MEDU-123456.7
I have seen a couple of IF, SUM and MATCH formula's, which I could do, but... I need to see if there is something simpler first because the people who will be using it are not as confident with Excel
thanks in advance
Steph x