Today we look at a question posed in Episode #1358 "How did Mike and Bill predict the Super Bowl winner?" Bill gives us the answer in Episode #1365 - and announces the winner of the contest.
Transcript of the video:
Learn Excel from MrExcel podcast 1365: Green Bay Packers Hey, welcome back to another Learn Excel podcast.
I'm Bill Jelen from MrExcel.
You know, we need to go back and finish up episode 1358.
That was the crazy one where I was in Mike Girvin’s office and I allegedly found the missing episode; what was it?
1178 or whatever, or was 1270; I don't know.
I joked that I had a formula that would come up with the winner of the Super Bowl.
I entered some crazy formula using statistics that made no sense at all and the answer popped up as “Green Bay Packers” and I challenged the viewers to come up with how did I do that and we actually had five people who sent it in and they got it exactly right.
So here I have a number.
It's just the number 5.
I'm going to go Ctrl+1 and go to Custom.
Now Custom is where we can do all kinds of amazing things with our number format and what I'm going to do is, I'm going to say I don't want to display this as General and I don't want to display it with two decimal points instead in quotes I want to display “Green Bay Packers” and now any number that I enter will show up as Green Bay Packers.
It's pretty cool; you can also do this, you could actually combine the text so “Green Bay Packers will win by” and then the number code like zero.
See that the five shows up there.
So pretty wild what you can do here.
You can actually store something as a number but show it as text.
Click OK, there we go.
So if I change that number to19, Packers win by 19.
All right, so in that podcast down in Mike's office I just threw up any formula that would come up with a numeric value and bam Green Bay Packers look great.
All right, so hey the folks who came up with that answer; Noel, Richard, Bob, Stan and Reuvain.
I said I'd give away a copy of Mike's new book so we will do equal index of those five names.
=INDEX(I3:I7,Randbetween(1.5)) And all right, Noel hey, congratulations.
Congratulations to Noel and actually for everyone else on that cool idea.
I want to thank you for stopping by and we'll see you next time for another netcast from MrExcel.
I'm Bill Jelen from MrExcel.
You know, we need to go back and finish up episode 1358.
That was the crazy one where I was in Mike Girvin’s office and I allegedly found the missing episode; what was it?
1178 or whatever, or was 1270; I don't know.
I joked that I had a formula that would come up with the winner of the Super Bowl.
I entered some crazy formula using statistics that made no sense at all and the answer popped up as “Green Bay Packers” and I challenged the viewers to come up with how did I do that and we actually had five people who sent it in and they got it exactly right.
So here I have a number.
It's just the number 5.
I'm going to go Ctrl+1 and go to Custom.
Now Custom is where we can do all kinds of amazing things with our number format and what I'm going to do is, I'm going to say I don't want to display this as General and I don't want to display it with two decimal points instead in quotes I want to display “Green Bay Packers” and now any number that I enter will show up as Green Bay Packers.
It's pretty cool; you can also do this, you could actually combine the text so “Green Bay Packers will win by” and then the number code like zero.
See that the five shows up there.
So pretty wild what you can do here.
You can actually store something as a number but show it as text.
Click OK, there we go.
So if I change that number to19, Packers win by 19.
All right, so in that podcast down in Mike's office I just threw up any formula that would come up with a numeric value and bam Green Bay Packers look great.
All right, so hey the folks who came up with that answer; Noel, Richard, Bob, Stan and Reuvain.
I said I'd give away a copy of Mike's new book so we will do equal index of those five names.
=INDEX(I3:I7,Randbetween(1.5)) And all right, Noel hey, congratulations.
Congratulations to Noel and actually for everyone else on that cool idea.
I want to thank you for stopping by and we'll see you next time for another netcast from MrExcel.
