will like to generate a list of all 243 possible outcomes of five soccer matches.. im a newbie to this and will like a detailed help please
will like to generate a list of all 243 possible outcomes of five soccer matches.. im a newbie to this and will like a detailed help please
Cross posted on multiple sites, double posted on this site with a mod request in the other thread
im new to all these .. i just need help
A B C D E F G H 1 81 27 9 3 1 2 Row Game1 Game2 Game3 Game4 Game5B1:F1,A3:A25: Input 3 1 L L L L LB3 and across and down: =MID("LDW", MOD(INT(($A3 - 1) / B$1), 3) + 1, 1) 4 2 L L L L D 5 3 L L L L W 6 4 L L L D L 7 5 L L L D D 8 6 L L L D W 9 7 L L L W L 10 8 L L L W D 11 9 L L L W W 12 10 L L D L L 13 11 L L D L D 14 12 L L D L W 15 13 L L D D L 16 14 L L D D D 17 15 L L D D W 18 16 L L D W L 19 17 L L D W D 231 229 W W D D L 232 230 W W D D D 233 231 W W D D W 234 232 W W D W L 235 233 W W D W D 236 234 W W D W W 237 235 W W W L L 238 236 W W W L D 239 237 W W W L W 240 238 W W W D L 241 239 W W W D D 242 240 W W W D W 243 241 W W W W L 244 242 W W W W D 245 243 W W W W W
Last edited by shg; 11-12-2016 at 02:25 PM.
Entia non sunt multiplicanda sine necessitate
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks