VBA Excel 2010 How to Remove Duplicates from a Range or List with Multiple Columns using VBA

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024

Комментарии • 24

  • @sdj7204
    @sdj7204 4 года назад

    Alex appriciating your lecture, When finishing work, the grid line disappears, how can I prevent it?

  • @Dorigurl75
    @Dorigurl75 9 лет назад +2

    I'm not able to duplicate these results..can you give me a link to the video prior to this one that you reference in your opening comments? I searched through your videos but wasn't able to locate it....

  • @nsanerydah
    @nsanerydah 4 года назад

    Exactly what I needed! Thank you so much.

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so much.

  • @jonnathanjon1
    @jonnathanjon1 4 года назад

    Can you help how to trim, then remove duplicate and concate the selected range transposly adjacent to it using VBA. ?

  • @TheBiggs1066
    @TheBiggs1066 9 лет назад

    Thanks for this Alex. I tried this without "Columns:=Array(1,2,3,4,5,6)" and it still worked.
    What does this part do?

  • @FaizurRahman00
    @FaizurRahman00 4 года назад

    Superb and very simple, 👍👍👍👍👍

  • @meetmehta3321
    @meetmehta3321 5 лет назад

    Please help me in this concern
    I have data in two sheets. If one row of sheet1 match with any row of sheets2, then delete both the matching row

  • @baddie8020
    @baddie8020 8 лет назад +1

    i tried the code that you presented on the first part of your video but it's not working.

  • @burniksapwet
    @burniksapwet 7 лет назад

    I need help. Same concept but this time I only need the unique value left. Basically I need only the number 22 showing. Thanks.

  • @archanaaa2514
    @archanaaa2514 4 года назад

    How to remove all duplicate ? After executing also there were still 1's were der. How to delete those?

  • @McLag0n
    @McLag0n 8 лет назад

    How would you do this for a table "n" rows wide by "n" rows high?

  • @dilshanpeiris51
    @dilshanpeiris51 6 лет назад

    GREAT VIDEO LESSON.. THANK YOU VERY MUCH...

  • @sandiegomariano
    @sandiegomariano 6 лет назад

    It was very Helpful, Thanks

  • @jwuj97f
    @jwuj97f 9 лет назад

    Content is good; however, the screen in blurry. I can not see the code even after zooming in (full Page view).

  • @b2mgroup371
    @b2mgroup371 7 лет назад

    Excellent, thanks alot.
    Keep in touch

  • @heiditwenter7321
    @heiditwenter7321 6 лет назад

    Wonderful Thanks so much!!!!

  • @shaswatiroy6532
    @shaswatiroy6532 7 лет назад

    it is very compact and perfect. Thanks.

  • @pavankumar.hanmandla
    @pavankumar.hanmandla 11 лет назад

    Thanks for your tutorial.......

  • @badges3557
    @badges3557 7 лет назад

    How to extract all the duplicates in another table ???????

  • @adiltheprodigy8235
    @adiltheprodigy8235 6 лет назад

    Interesting

  • @maha_e_suvidha
    @maha_e_suvidha 5 лет назад

    Out of memory