Not sure if Excel can Predict

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,
I have an issue where I want to "predict" the next set of numbers in a
list. The list though is "random" in the fact that it it is runs from 1 - 100

example:

Column 1: 02, 99, 84, 16, 35, 33, ......

My question is there a formula in Excel that looks for patterns? or a Macro
that can be created to look for patterns in seemingly random numbers. I have
even tried to reverse engineer some of those random generators to see if it
can be built.

If this is the wrong group to ask, but anyone knows the correct group (like
C+, or VB) I would appreciate any assistance.

Thank you,
David
 
David,

No. Excel cannot predict series of random numbers.

HTH,
Bernie
MS Excel MVP
 
Back
Top