Friday Poser

What's the next number?

2, 9, 16, 23, 30, 6, ?
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Is it?

2, 9, 16, 23, 30, 6, 13, 20, 27, 34, 10, 17, 24, 31, 38
 
It was correct up until the 27 then it wasn't.
 
What's the next number?

2, 9, 16, 23, 30, 6, 13, 20, 27, ?
 
jonmo had the original correct answer up to the 27 and barry has the next correct number after that :)
 
I'm assuming it's date-related, Fridays in 2009 for instance, just the day, in which case it would go like this:

2, 9, 16, 23, 30, 6, 13, 20, 27, 6, 13, 20, 27, 3, 10 ......
 
Right seeing as how there are minute left of friday I'm going away with a caravan tomorrow

30,

What should be the next number

1? [Logic being that you posted on May 1st, 30 was the DAY() of posting date - 1.]
 

Forum statistics

Threads
1,222,646
Messages
6,167,311
Members
452,109
Latest member
nathanle89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top