I have a column of price data. I want to identify which cell has max value
and set a text "max" for indication.

Col A Col B
10
3
6
2
12 max

I only know the max(A$1:A$5), but not know how to set text with it. Please
help.

skysusan