Hi All
I am really hoping someone clever can help with a solution, as I've got a real puzzler that I've been unable to crack the last 2 days! >.<
I have a data set with account IDs from 4 separate systems. They should all be the same, but sadly they're not
So I've added a column called 'Distinct' to alert us to any rows where the 'Acc ID's don't match.
But (and here's the pesky bit) annoyingly some of the cells contain string values that begin with a '#'.
I am unable to remove them from the data, so need to find a way to exclude them from the calculation in the distinct column
I've been trying the advice here but have been unable to get anything working
"get-digital-help.com/count-unique-distinct-values-that-meet-multiple-criteria-in-excel"
[I'm not allowed to post proper links yet]
Sample workbook attached
Any help would be massively appreciated as I am totally stuck!
All the best
Vicky
Bookmarks