B
Bud I
A B C D
Cur Prchs Prev Cur
Prc Prc Max Max
==== ==== ==== ====
10 8 11 11
12 13 13 13
15 12 13 15
Col A, Current Price, changes daily
Col B, Purchase price is constant
Col C, Previous Max from yesterday
Col D, Current Max = MAX(A,B,C)
If C is less than D, then Copy D to C
Using Excel functions, this results in a circular error
The solution is a piece of cake in Fortran (remember that?), but my
VBA isn't up to it.
Help!!!
- bud -
Cur Prchs Prev Cur
Prc Prc Max Max
==== ==== ==== ====
10 8 11 11
12 13 13 13
15 12 13 15
Col A, Current Price, changes daily
Col B, Purchase price is constant
Col C, Previous Max from yesterday
Col D, Current Max = MAX(A,B,C)
If C is less than D, then Copy D to C
Using Excel functions, this results in a circular error
The solution is a piece of cake in Fortran (remember that?), but my
VBA isn't up to it.
Help!!!
- bud -