Duplicate Data Issues

[Rock_boy]

G'day, I have a dataset (Sample Attached) which has an existing Dataset in columns L through P and new data in columns A through K. I need to clear the content in columns A through K for those samples which exist in both columns K and L while leaving L-P intact, they are also distributed randomly throughout my dataset so can't match them row by row
Trial.xlsx.

[MarvinP]

Hi Rock_boy,

See the attached where I inserted a col K to see if any of the stuff in K matched. I don't think any of your column L matches in K. See attached and formula in L

[Rock_boy]

In the original K21 cell was equal to L123 so there are some matches in there but like i said this has given me a headache and nothing I have tried has worked

[MarvinP]

Hi Rock boy,

I think I have a better answer for you. There is a space in front of all the K Column stuff. Try this better answer.

[Rock_boy]

Your a legend, some days I shouldn't get out of bed.