Forum Discussion
How to Remove Actual Duplicate Values
Problems!!! I have a database. Where there is a column called NID. NID numbers are usually 10, 13 and 17 digits. After applying the duplicate value in the NID column, I see that if the 10 and 13 di...
In this case ID numbers are saved as text, but counting duplicates Excel interprets such texts as numbers, for which it keeps 15 digits maximum. If work with numbers using the rule with formula
=SUMPRODUCT(1*(C3=$C$3:$C$1489))-1it operates with 17 digits maximum and returns duplicates correctly.
If you have more than 17 digits that doesn't work as well. If so it'll be more reliable to create helper column with texts like ="abc" & C3 and check duplicates on this column.
Please check attached.