Wonder if you guys could assist...
So, i have two columns with unique identifiers, column A = unique identifier 1 and Column B = unique identifier 2... Column A is unique to a record and column B is to distinguish between multiple records so concatenating the two will result in a totally unique value.
What i need is a formulae which can count how many lines which are not unique when combined.
I'd rather not have another column when concatenated, can this be done in a single formulae?
Bookmarks