Basically this is what I am trying to accomplish:

Column #1 -
This column will contain a formula that updates when an variable cell
value is changed elsewhere in the spreadsheet.

Column #2 -
I would like this column to update and display the value in Column #1
ONLY when the value in Column #1 is greater than the current value in
Column #2.

This should produce the maximum value over a long series of
calculations as I change a variable. The tricky part is I would like
to do this over a range of 300 cells without typing in a ton of VBA
code. If anyone has any suggestions please let me know.

Thanks,

Bryan