copy unique values

  1. M

    extract or copy only one value that's unique across multiple columns

    Hey, guys! I have a 10-column sheet with both unique and non-unique values (which are actually text, not numeric values, if this matters) across different columns. For example... column 1 has 27 rows of text, column 2 has 33 rows of text, column 3 has 14 rows of text, column 4 has 62 rows of...
  2. M

    1st Unique value show twice VBA

    I tried this code to copy and paste unique values but 1st value comes twice. Dim cell As Range, areaToTrim As Range Set areaToTrim = ActiveWorkbook.ActiveSheet.Range(Selection.Address) areaToTrim.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("I4"), Unique:=True Range("I4"...
    • miqbal
    • Thread
    • copy unique values first duplicate value remove duplicate values unique values vba
    • Replies: 1
    • Forum: Excel Questions
  3. G

    VBA Copy Unique Values from Column with Blanks

    Hello Amazing Excel Gurus, I have been struggling with this one for far too long and I still can't figure out what I'm doing wrong. I will try to be as clear as possible: My spreadsheet has a list of user numbers in Column I. The length of data varies each month and there are duplicate user...

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