match rows from 2sheets

  1. I

    Match a range of rows together from two datasheets and keep the rows that match

    Okay, so I have a range of records taken from an export in rows numbered by an UID, the ID jump in number and there are about 1500 of them. I have another export in a different sheet that doesn't jump in number; there are about 26000 of these. How do I match up these records by ID and only keep...
  2. A

    Compare two sheets using match/find

    Hi all.. Glad to know this forum.. I have problem with my macro excel. I want to compare 2 sheets (1st Semester & 2nd Semester), the result is in the Sheet Output. My problem is there is possibilities that there are some values have duplicates. For example, there are 2 "Budi" Grade "7" in...
    • Azurai
    • Thread
    • excel vba macro match match rows from 2sheets
    • Replies: 6
    • Forum: Excel Questions
  3. P

    Match / Compare values between two ranges and loop it

    Hello, I am struggling with trying to create a macro and hope I can get some help. I have one sheet (called Sheet1) with 58 columns and about 30,000 rows of data. I am trying to check if values from another sheet appear in the first one and assign a value to against each row if it matches the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top