SOLVED

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)
Solution

@Angela_Atkins 

Count unique values among duplicates

Excel specifications and limits

 

Hope I was able to help you with this links.

 

NikolinoDE

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.      

1 best response

Accepted Solutions
best response confirmed by Angela_Atkins (Copper Contributor)
Solution

@Angela_Atkins 

Count unique values among duplicates

Excel specifications and limits

 

Hope I was able to help you with this links.

 

NikolinoDE

I know I don't know anything (Socrates)

View solution in original post