2 part piece here. One part counter of up and down, fill in of blank cells.

Ok guys. This one might be more than someone wants to try to tackle. If it's too much of a problem and would take a lot of time, then please don't fool with it. If it isn't to bad then i think it's all i need to finish up what I'm working on. I have a small amount of formula writing abilities, but when it comes to the modding and all that like was done to the even odd one you guys worked on for me I am long lost. Here is the one that ya'll helped me with on the even and odd:

http://www.excelforum.com/excel-form...-column-2.html

What i have uploaded here is similar in workings to the link. This new one counts larger than and less than instead of even and odd. For the first part of what I'm needing to do, i need it to find if the new number put in is larger than, or less than the previous one. Whichever it does i need it to count up from the last number in the column. If the new number is = to then i need it to check the previous cells to see if the previous cell was larger or smaller. I think i have it described better in the example than i can here.

Thank any and all very much again!!! Like i said, if it's too much or gonna take a long time, then don't even fool with it.

This is the larger than formula i have in there now:

=IF('Numbers UD-EO'!B700='Numbers UD-EO'!B701,"?",IF('Numbers UD-EO'!B700>'Numbers UD-EO'!B701,"1",""))

I don't need the ? in the first part of the formula. I need it to, if it is = to the previous number to check that previous number with the number before that and go from there to make the decision. For the result of the formula, if this cell is larger than the previous, i need it to count up from the last time it was larger than in the same column. If it was less than it will do the same in the correct column.

Ok. I guess this was too much for someone to tackle. Thats ok. I pretty well understand the regular formulas and such. When it gets into the MOD, AND and such I am just lost.
I can pretty well get by by copying and pasting the small font numbers in each time. I can even get by with changing each of the 1's that my formula will put out for me. If there is anyone that can help me with the adding up of the 1's like ya'll did with the post linked above that would be nice to be able to put into my workbooks. If not that's ok. I'm just thinking about passing my work on to some other people is why I'm wanting to fully automate it.

Here is one of what i started out with on the even/odd formula: =IF(ISEVEN('Numbers - EO'!B701),"1","")

This is what a member changed it to, to make it count up: =IF(AND(MOD('Numbers - EO'!A701,2)=0,MOD('Numbers - EO'!B701,2)=1),1,"")
followed in the next cell by this formula : =IF(AND(MOD('Numbers - EO'!A700,2)=0,MOD('Numbers - EO'!B700,2)=0),MAX(B701:$B$701)+1,"")
then drug up to where i decided to stop it. This would count up all the 1's that my formula did.

I can see nowhere in either of these formulas which would indicate either even or odd is why i can not figure out how it works. I only know that it does work. Does the MOD or AND in it go over top of the formula that i already have in the cell and do the counting? I really am lost big time at this part.

What i need to do is have my greater than and less than formula count up like this made my even/odd do. If that is fairly easy. Or if someone can explain how this AND,MOD worked/works. Whichever may be easier to do. I'd really like to know how this worked either way.

Thanks a bunch!!!!