Need help for duplicate results RRS feed

  • Question

  • Is there any examples that i could filter duplicate values of excel and move them to be show on userform of the listbox?

    Friday, July 13, 2012 9:37 AM

All replies

  • if you are using 2010 of Ms.Office, then you have an option on Excel ribbon - REMOVE DUPLICATES when you click on the DATA menu item.

    Next: select the addres in the list item's source property

    eg:  if you have the non duplicate items in range a2..a22 then in the ROW SOURCE property - type a2..a22.

    This will solve your problem.

    Repath Athyala

    Love the Love that Loves the Love and Hate the Love that Loves the Hate.

    Friday, July 13, 2012 10:22 AM
  • You can use one of procedure from Unikaty dla zakresu lub stringa


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Saturday, July 21, 2012 11:41 AM