Share via

Excel Bug on "duplicate values"

Anonymous
2021-08-09T02:15:13+00:00

There is a bug on the Microsoft 365 Apps-Excel.

The function "conditional format --> duplicate values " can't recognize the number(stored as text) larger than 14 digits. If the text length is longer than 14, and the former 14 byte is same while the left is different, the function will only judge the first 14 byte, and give the conclusion that the data are same.

Hope it could be solved soon.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2021-08-09T03:54:37+00:00

    That will never be solved due to the design of Excel.

    But you can use a workaround:

    Add a non-numeric char anywhere (front or end):

    B1: ="x"&A1

    Apply the CF on that column.

    Andreas.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-16T02:44:14+00:00

    really helps.

    thanks so much~

    0 comments
  2. Anonymous
    2021-08-16T02:53:50+00:00

    PS: sames the function"remove duplicates" use a different logic, it will recognize the long number (stored as text), and keep the different ones.

    0 comments