Remove duplicates limitation?

Copper Contributor

Is there a limit on the number of characters that MS Excel searches to determine duplication?  If not, are there any characters/formats that it doesn't "like"? 

2 Replies
best response confirmed by Angela_Atkins (Copper Contributor)


Count unique values among duplicates

Excel specifications and limits


Hope I was able to help you with this links.



I know I don't know anything (Socrates)

@NikolinoDE I appreciate the info.  It did not address the character limit for determining duplicates, so that means the question is either too detailed, or there is no limitation (the entire field is considered, up to it's character limit).  Just can't be sure.