Two columns unique distinct values to listbox

Originally Posted by jindon

What if there is another 5 in sheet1?

Do you need 5,5,7 or 5, 7?

example
1. Sheet1 numbers 1 2 3 4 5 6 7 8 9 10
sheet2 numbers 1 2 3 4 6 8 9 10

the userform in the list box show numbersAttachment 724995