Need formula that can compare E and O like a U or D

[Jack-P-Winner]

I will try my best to explain. I have a formula that places a U for Up or a D for Down. Here is an example:

=IF(Link!B2="?","",IF(Link!B2>Link!B3,1,IF(AND(Link!B2=Link!B3,Link!B2>Link!B4),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2>Link!B5),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2>Link!B6),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2>Link!B7),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2=Link!B7,Link!B2>Link!B8),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2=Link!B7,Link!B2=Link!B8,Link!B2>Link!B9),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2=Link!B7,Link!B2=Link!B8,Link!B2=Link!B9,Link!B2>Link!B10),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2=Link!B7,Link!B2=Link!B8,Link!B2=Link!B9,Link!B2=Link!B10,Link!B2>Link!B11),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2=Link!B7,Link!B2=Link!B8,Link!B2=Link!B9,Link!B2=Link!B10,Link!B2=Link!B11,Link!B2>Link!B12),1,IF(AND(Link!B2=Link!B3,Link!B2=Link!B4,Link!B2=Link!B5,Link!B2=Link!B6,Link!B2=Link!B7,Link!B2=Link!B8,Link!B2=Link!B9,Link!B2=Link!B10,Link!B2=Link!B11,Link!B2=Link!B12,Link!B2>Link!B13),1,""))))))))))))

When I use this and do a reset which basically moves all the Us and Ds down 1 row for the most part it works okay. Actually the first row does not work correctly but the ones that follow do.

What I am trying to figure out is I have E for Even and O for Odd and I am actually counting how many times a number is even or odd so the numbers change of course and when I do a reset to go to the next row all the E's and O's are getting mixed up. Is there a way to write a formula that can perhaps capture the change and still give an output of an E or O? This may not even make sense what I am trying to do. Here is a picture of the Us and D's which is a before and after. When I do a reset they all move down a row. Game 50 goes to 49, Game 49 goes to 48, Game 47 goes to 46 and so on. You can see the Us and Ds follow suit pretty well BUT the Es and Os do not. I am looking for a way to have the E's and O's do the same and follow suit

 

[Jack-P-Winner]

Here is the UD before and After and the book with the formulas. The actual formula is on the tab #1-O-E and UD-EO#1. The pictures are on the start tabs for the E-O and EO

Thank you all!!!