Identify the cell with Max & Min values

G

Guest

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
 
B

Biff

Hi!

If just want the MAX value identified, enter this formula in B1:

=IF(A1=MAX(A$1:A$5),"max","")

Copy down to B5.

If you want to identify BOTH the MAX and MIN, enter this formula in B1:

=IF(A1=MAX(A$1:A$5),"max",IF(A1=MIN(A$1:A$5),"min",""))

Note: if the value is both MAX and MIN at the same time the formula will
return "max".

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max If function 1
Help with time function 4
Max Value, Sum Product, Between Date Range 3
Making MAX and MIN range variable 1
MAX() and MIN() 4
Max Value - based on a time period 3
Find the Cell Reference Resulting from MAX function 1
Max and Min in a Range 1

Top