I coded this quite easily in Java but, having never looked at VB/VBA until today, I am having trouble translating this into something Excel can do.

Here's what I need to do. Read the first four cells in a column and compare their values. I am looking for instances where the value of the cells increases three consecutive times, then compare the value of the fourth cell to the third and record to, say, variable A if cell4 > cell3, variable B if cell4 < cell3, and to variable C if cell4 == cell3. Then move down one row and repeat. Continue until it reaches a blank cell, and display results for A, B, and C.

I have pasted a bit of the Java code below, just in case my above explanation was unclear. The logic should adequately explain what I need to accomplish.

Please Login or Register  to view this content.