duplicate value in column

  1. C

    Remove Duplicate based on Time

    I have a spreadsheet with 3 columns: Usercode, Date Accessed and Time Accessed. The major sort is Usercode and then a minor sort by Date Accessed and then Time Accessed. I need a macro that will remove all of the duplicate Date Accessed for each unique Usercode and the remaining Date Accessed...
  2. N

    Highlight Duplicate Value, 3 Column check

    hi, I need to find duplicate in a set of data mentioned below in which there is three columns Date, Employee Code, Amount. These 3 column we need to check in each row to identify the duplicate. In the given data 2 Lines with emp code AHP-SHJ-06-07 and AHP-SHJ-06-03 is duplicate...
  3. A

    Remove duplicate values in rows and cells

    Hello everyone, Is it possible to gather a list of unique items from a selected area like 50rows x 50columns ? As far as I know, removing duplicates from excel includes columns only. But I do have a data which is 50x50 cells and have to see all unique items at once. Otherwise I have to do it...

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