Excelestial
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 828
I was waiting for the punch line myself. Thought maybe there was a mystery number in there or something. I got 4100 also.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Brain Teasers
- Thread starter schielrn
- Start date
Excel Facts
Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,651
- Office Version
- 365
- Platform
- Windows
Yes, that was on the first attempt and did it 4x in my head again in case I was missing something.
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,651
- Office Version
- 365
- Platform
- Windows
What are the next two lines in this sequence:
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| F | G | H | I | J | K | |||
| 1 | 1 | 1 | ||||||
| 2 | 2 | 1 | ||||||
| 3 | 1 | 2 | 1 | 1 | ||||
| 4 | 1 | 1 | 1 | 2 | 2 | 1 | ||
Sheet1 | ||||||||
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,121
- Office Version
- 365
Erik solved that 2 years ago 
(spoiler alert)
http://www.mrexcel.com/forum/showthread.php?t=256047&page=2
(spoiler alert)
http://www.mrexcel.com/forum/showthread.php?t=256047&page=2
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,651
- Office Version
- 365
- Platform
- Windows
OK, how about this one?
A man is trapped in a room. The room has only two possible exits: two doors. Through the first door there is a room constructed from magnifying glass. The blazing hot sun instantly fries anything or anyone that enters. Through the second door there is a fire-breathing dragon. How does the man escape?
A man is trapped in a room. The room has only two possible exits: two doors. Through the first door there is a room constructed from magnifying glass. The blazing hot sun instantly fries anything or anyone that enters. Through the second door there is a fire-breathing dragon. How does the man escape?
Marbles
Well-known Member
- Joined
- Feb 7, 2005
- Messages
- 627
Another two doors.
Stuck in a room with two doors, each with a guard. One door leads to freedom, one to death. You're allowed to ask one question only, to find the right door. One guard will always tell the truth to your question, the other will always lie. What do you ask?
Stuck in a room with two doors, each with a guard. One door leads to freedom, one to death. You're allowed to ask one question only, to find the right door. One guard will always tell the truth to your question, the other will always lie. What do you ask?
