I need an Excel macro based on my requirement. This Excel give me all combination of teams for fantasy to bet in IPL match. There will be 2 teams and 22 players from both the teams where I should have at least 1 keeper, 3 batsmen, 1 all-rounder, and 3 bowlers out of 22 players and minimum 4 players from a team. This means, If I paste 22 players along with thier roles like bat, bowl, allrounder, keeper, and run macro, it should give me all possible combination of 11 players. Also, each player will be awarded credits. And sum of credits for a team created, it shouldn't cross 100 mark. I want a person who has knowledge on Indian Premier League fantasy game.
6 pekerja bebas membida secara purata ₹1133 untuk pekerjaan ini
Hi, I have so much experience on Excel/Macros/VBA for more than 11 years. I am pretty sure I can help you to get a great result. We can chat to discuss details and be more assertive in what you want. Thank you!