Hello everyone,
I'm new to excel and VBA and i don't know how difficult or stupid this may sound, but i still couldn't solve it
I'm trying to make a function in VBA that takes a list of 19 unique names, then outputs all possible unique combinations of 16 names from that list. (kind of like C(19,16)). which i think will give a 969x16 table.
let's say instead of names, the list had integers from 1 to 19.

list = {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19}

can anyone show me how this should be done?

Thank you a lot in advance