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]

12		?	?	?
11		O	I	O
10		O	O	I	TRYING TO FORCAST OR READ PATTERNS
9		I	O	I	IF THERE IS A PATTERN WHAT WOULD BE NEXT O OR I
8		O	I	I	FOR LINE 12 WAS WONDERING HOW IT WOULD BE DONE
7		I	I	O
6		O	I	I
5		O	I	I
4		I	O	I
3		I	O	O
2		O	O	O
1		O	I	O

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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).