Same ID column A different CSV values on various rows

[grphillips]

Hello All,

I am trying to identify what ID’s in column A have different CSV values on multiple rows?


Some IDs will be unique , other IDs in column A will be shown more than once.


Could be 1000s of IDs

Example attached.

Best Regards,

[k64]

Try this:

Please Login or Register  to view this content.

[grphillips]

Hello,

Thankyou, I have added 2 extra columns to the output and a few extra lines with another difference example. Can the code be modified to add the extra 2 column outputs?

I have populated the spreadsheet attached with comments.


Thanks Very Much

[k64]

Do you care about knowing what the difference is, or do you need just need the full complete org? Strangely, it's actually easier to get the full complete org than the differences.

[grphillips]

Hello,

I think your right, the column Full Complete Org is more useful.

Thanks.

[grphillips]

Full org is fine. thanks

[grphillips]

Hi there/All,Thanks again some feedback I tested the original today on a normal PC. Unfortunately it did not work.

It stops at the below code and says sub or function not defined??

With Sheets("Sheet1").Range("A1").CurrentRegion.

Would you mind testing and correcting. Please advise.

As above don’t worry about the difference but would you mind adding extra code to capture full org and additional column?

Thank you,

[k64]

I'm guessing you don't have your sheet named "Sheet1"? I'm working on code for the full org, but have to go to bed now, so I'll finish it tomorrow.

[k64]

Okay, this should work for getting the complete org.

Please Login or Register  to view this content.

[arlu1201]

Thread posted in Commercial services, hence closed.