Excel Spreadsheet and VBA macro to Generate Combination List
$30-100 USD
Terminado
Publicado hace más de 6 años
$30-100 USD
Pagado a la entrega
I am looking for an Excel and VBA expert to create a spreadsheet capable of generating lists of names. For example, out of 8 names, I want a list created by choosing only 3 names at a time - which should produce a list totaling 56 combinations. It is a "n choose k" combination problem without replacement where order is not important. For the list, I would like flexibility in the total number of names and the selection size. However, I don't think the list would be greater than 15 names and I would not select less than 6 names at a time. For each list, names should be in a separate cell and each list should be on a separate row. Lastly, I would like to exclude the possibility where two names can't be within a list combination at my discretion.
Hello,
My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete.
Also I will provide you with a sample work before you may please consider awarding me the project.
Thanks,
Jay
Hi, I am an Excel VBA expert and can take on your project. Can I assume there will be no duplicate name in the list ? Shall take care of the exclusion rule.
Hi, from your brief I think you need some string manipulation VBA function. I hope I can help you. Off course I need to ask some questions for you. I'm waiting your reply, Thank you.