remove diplicate options

  1. A

    Find unique values

    Hello everybody I am facing a problem and I hope you can help، I have two lists in two different columns and I want to have the unique values in a separate column. Is there any way? ABC1List 1List 2Unique2Andrew CenciniMichael Neipper3Jan KotasNancy Freehafer4Mariya SergienkoMariya...
  2. A

    Duplicate Records

    I know, it's late and I can't think anymore. I have reports to run monthly and I need to remove the duplicate records. Columns A & B are the records from the previous month, from Column C on is the current report run. I am able to highlight the duplicates, but I need to know if there is a fast...
  3. U

    Take out diplicates in combo box

    Hello, I have created a form with a combo box. The combo box should only have 4 options (North America, Latin America, Europe and Asia). However, since the data behind the combo box is a query it shows ALL the lines of data and their option. So in my drop down list I have many North American...

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