none
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.

    Regards
    Repath Athyala
    www.repath.wordpress.com


    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

    Regards


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Saturday, July 21, 2012 11:41 AM
    Answerer