dupes

  1. J

    find dupes and hide non dupes

    hi i have a spreadsheet with several thousand rows. i know how to find dupes (through conditional formatting) - but i don't know how to filter to only show the dupes is there a way someone can share with me? thanks so much =) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font...
  2. E

    How do I use Index match to Return values from One Column based on Comparison between 2 Columns when there are dupes

    HI All, I have the following scenario I am using the following formula =INDEX($A$1:$B$12,MATCH(C1,$B$1:$B$12,0),1) to perform something like Name 5 in Column C, should print oimnlu in Column D, based on Name 5 value in Column B. This works fine as long as there are no dupes in Column B...
  3. M

    Remove highest rows of duplicate data

    I'm running a process that imports data into a excel table and this can be done multiple times, so I want a way to remove the older instances and only keep the newest, which would be furthest down the table. When I've tried using the remove dupes function it always removes the bottom values, is...

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