duplicated data

  1. E

    Identifying duplicate values in the same cell, where the data is separated by a pipe.

    I have a large Excel file with over 85k rows, that I feed into our system to read and apply the data. I have a field where my values are separated by a pipe as shown below: NU001|NU002|NU003 BA001|BA001 BE001|CS001 I am trying to figure out how to identify rows where the data on...
  2. S

    How to remove duplicates in certain columns?

    Hi, this is my first time to post here. I found excel can remove duplicated data in this article. It gave an example but I am still confused. I am not sure how to remove several columns instead of just one?
  3. lani_berina

    Duplicated values / data

    Hi everyone, I need help on how to find duplicated values / data from the master list in col O2:O241 to sheet1 col. B1:B125, SHEET2, COL. B2:B10 and to SHEETB COL B2:B10. <tbody> O B B B 23232 23233 454545 54545 55664 64646 464666 64654 MASTER LIST SHEET1 SHEET2 SHEET3 </tbody>...
  4. A

    getting best of two scores of the same student

    Hi all, i am new around here. I have what i think is a unique problem with excel. In column A i have thousands of student names and column B i have scores of these students for a test. Most students in column A have appeared twice and have got different scores, and hence their name appears...

Watch MrExcel Video

This Week's Hot Topics

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
Top