Multicolumn Listbox - How to remove duplicates and sort by first column?

[s2jrchoi]

All,

I am trying to figure out how to remove the duplicates in my listbox. Here is my code to pull data into the listbox. However, I noticed that if someone partially paid an invoice and made two payments to one invoice, the listbox will show the invoice twice with the same balance. Is there a way to remove the duplicates from the listbox? Also, is there a way to sort the listbox starting with the 1st column?

Please Login or Register  to view this content.

Thank you in advance for your help.

J

[s2jrchoi]

It appears there are many posts about removing duplicates in single column listboxes but I can't find any that relates to multicolumn listboxes. Can anyone please help?

Thank you!

[s2jrchoi]

Can someone please help me with the code? It picks up duplicates and I don't know how I can get it to not pick up duplicates. Any suggestions will be greatly appreciated. Thank you!

[nilem]

Hi s2jrchoi,
could you attach an example of your file

[Sean Thomas]

you could try this

http://spreadsheetpage.com/index.php..._unique_items/

it adds each value to a collection(Array) if the value alreay exists it causes an error and then moves onto add the next value

i can only suggest you create another collection for the 2nd value or add them to a new list on a sheet based on if the first value is added to the collection.

hope it helps, cant try it out myself as just about to finish.

good luck

[s2jrchoi]

Hi nilem,

This is the best I can do. I created a sample workbook with sample data. Please take a look. Sometimes we send out invoices with negative invoice amounts and because of this, the invoice shows up twice when it should only show up once. Please let me know if you have any questions. I will try my best to answer them.

Thank you again for your help!!!!!

[s2jrchoi]

Thanks Sean. I will take a look at this and see if I can incorporate them in my workbook. Thank you again!