outcomes

Hi - first time posting here. Hope you can help. I'll try and be as clear and as concise as possible. I have 12 questions (which form part of an assessment). Each question carries a simple "Yes" or "No" answer. This gives me 4096 different possible outcomes (2^12), for a completed assessment...

Hi All, First time posting, been a long-time reader. I have a question that I'm sure would have been looked in to before but cant seem to get a fix via solver or any of my own VBA work. I have a model with 96 different possible outcomes dependent on the variables in 4 different drop down...

Hi All, I have survey results that come out like the attached. I need to produce a report from this and would like to have a table by each area. Eg. Alignment to Outcomes and list the comments without the blank cells, and then the "agree, diagree etc... " I tried using the below, but it...

Hello, I tried to do an index match on the same column (the image below is an simplified example). Unfortunately, I tend to get strange outcomes but cannot see why. Only the '4643358' at Q9 seems to be working. The formula I used was: =INDEX($B$2:$B$14,MATCH(P2,$B$2:$B$14)) Anyone got an...

I have two drop-down list boxes with multiple options to choose from in each box. Doing the math, there will end up being 300+ outcomes in the destination cell. I thought about doing IF AND statements and I'm pretty sure excel won't allow for that to happen. I have tables with all of the...

Hello Excel lent people My challenge is i would like to generate all betting possibility in a 13 Matches,with 2 games each ,with usual outcomes of 1,X.2 such that there will be 3^13 outcomes -1594323 results, I dont know much about Excel/VBA formulas but i would really like to have a...

How many possible outcomes are there in 8 soccer matches

I am making a table for outcomes but I don’t know how to make my idea reality. I want to have 2 sheets. First sheet is where to write the outcomes and it should looks something like this: On the second sheet is where it comes hard. The sheet should looks like that: I want to input the...

Hello, I have been reading on the internet that there is a previous quarter function, but cannot find any examples of how this works to amend my formula. currently my formula is =COUNTIFS(Outcomes!$D:$D,PRISM_LINKS!$B3,Outcomes!$U:$U,"issue identified - wrong customer...

Hi guys Basic one for you - data as follows: <tbody> A B C D 1 1 3 Y 2 3 7 Y 3 7 1 N 4 5 5 M 5 2 1 N </tbody> I want a formula in D1 that: > looks at C1 - if "Y", shows A1 - if "N", shows B1 - if "M", shows 0 Is that do-able...