Thanks. Now what is the formula for finding the largest value and then
inserting $200 in the next column, same row?

"Mike H" wrote:

Maybe

=Max(A1:a100)

Mike

"Donna" wrote:

How do I find the largest value in a range?