Concatenate multiple columns and then look for duplicates is NOT WORKING

[StaceyFCreative]

****UPDATE - I think i just need the formula to find duplicates when I have over 255 characters, it needs to find the duplicates throughout the whole dataset, not just comparing the first record to the rest.****

I want to maintain a log of service reports. Each row represents a service report.

Each day I am getting a new report of open service reports and I am concatenating all the information in order to check for changes in the data set. In column A, orange=original set, blue=today's records

I concatenate all of the columns (into column W) and then look for duplicates. The columns that don't show a duplicate I will look at further to identify the change. The duplicates in the new data set only get deleted.

HOWEVER, the sample data I have provided should all show as duplicates and I don't understand why they are not.

Help

[PaulM100]

Use this. Is an array formula so Ctrl+Shift+enter instead of regular enter:

Please Login or Register  to view this content.

[torachan]

Untried,
start your string of with a 'letter' (the same letter).
Concatenation works with 'text strings', you are starting yours off with a 'date'.
the lead letter may set the string.

[menem]

I think it can only test for 254 chars or less in condition format (duplicate).

Regards.