Want to show name without duplicates Using FIlter Data Using ListBox

hello evryone
i m filtering data using listbox (userform).

i want listbox show only names(without duplicates)

thanx

Hi,
instead of hardcoded list fill range, did You tried to loop through all non blank cells in column 3, and with simple testing add the item that occures for the 1st time to Your listbox list?

Please Login or Register  to view this content.

Do not forget to clear rowsource range in listbox properties.

Hope it helps

Regards

M

Please Login or Register  to view this content.

Hello Miroslav

great, works perfect

thanx a lot

hello jolivanes

thanx a lot u too