How to see or forecasting patterns

[Landon1111]

For example
Is there a way for excel to see what would come out after the blow pattern
Going from bottom to top

? ? ?
OOO
I. I. I
I. I. I
OOO
OOI

 

[Fazza]

Yes, if you load the information into a custom list.

 

[Landon1111]

[TABLE="width: 720"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]TRYING TO FORCAST OR READ PATTERNS [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD]I[/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]IF THERE IS A PATTERN WHAT WOULD BE NEXT O OR I [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD]FOR LINE 12
WAS WONDERING HOW IT WOULD BE DONE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]I[/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]I[/TD]
[TD]O[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]O[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]O[/TD]
[TD]I[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Landon1111]

yes, if you load the information into a custom list.

how?

 

[Fazza]

Refer Excel help.

Or via google, this is from the first hit I found,

Create your own custom list

• In a column of a worksheet, type the values to sort by, in the order you want them, from top to bottom. For example:
• Select the cells in that list, and then click File > Options > Advanced.
• Under General, click Edit Custom Lists.
• In the Custom Lists box, click Import.

 

[Fazza]

And then to use it, if you select the current last TWO entries and drag down the fill handle, it will fill in the next entry (from the custom list).