Shippwreck
Programmer
Hi,
I was playing with a spreadsheet that had a number of random numbers in. I then thought i wonder what autofill makes of the next number so i did it. I then tried to work out how it came to that number, but have no clue, so does anyone know how or why it chose it, below is the list and what excel decided the next should be:
3, 6, 11, 26, 3, 2, 9, 2, 7, 6
Next according to excel = 5
These were simply placed in cells A1 to A10 where A1 = 3 and A10 = 6, and then highlighted autofilled to cell A11 which came out as 5, why?
Thanks for your help
"Google is god...of the internet" - Me
I was playing with a spreadsheet that had a number of random numbers in. I then thought i wonder what autofill makes of the next number so i did it. I then tried to work out how it came to that number, but have no clue, so does anyone know how or why it chose it, below is the list and what excel decided the next should be:
3, 6, 11, 26, 3, 2, 9, 2, 7, 6
Next according to excel = 5
These were simply placed in cells A1 to A10 where A1 = 3 and A10 = 6, and then highlighted autofilled to cell A11 which came out as 5, why?
Thanks for your help
"Google is god...of the internet" - Me