Find exact match in multiple columns in 1 row with all other rows 90,000 rows.

Hello and thanks for any help you can provide.

I have searched and tried for two days now for a formula that can do the following. Then I wrote this and realized that I probably need a macro to do this.

I have a spread sheet that is 90,000 rows, with multiple columns. It has multiple functions, sales orders and deliveries and so on. I need to sort data based off two of the columns, to filter out repeat orders.

The two columns have repeating part numbers and prices. I have parts with multiple pricing. I need to find the common ones and filter or delete not sure of that step right now.

Example….
B3 = 5 C3 = $.0064

I need to find and flag the rows that have the same data in the B and C column. Then move to the next row and check it against all rows.

If it doesn’t match anything don’t flag it, if it does match, flag what it matches and not itself.

Flag it by placing an (X) in column (A) of the matching row, then if there is an (X) at the beginning of the row do nothing and move to the next row.

I attached a file with a simplified format of what I need sort. Work sheet.xlsx

Thanks again,

My solution about the same as the previous poster.

Just click the "Find and Flag" Button.

Worksheet - modified.xlsm

90,000 rows?? try this

Please Login or Register  to view this content.

Thanks every one for your help.

Your solutions work great, saved me hours of work and lots of headaches.

I learned something new from each and every one of you. Thanks again.

Regards,
KHurt