Highlighting the SECOND largest number in a column ?

Aitch

Board Regular
Joined
Jan 27, 2019
Messages
94
Office Version
  1. 2010
Platform
  1. Windows
I'm using Conditional Formatting with the MAX formula:

=A1=MAX($A$2:$A$222)

to find and highlight the highest value in the A column range


How can I do the same to highlight the second largest value in the column?


Thanks for the help!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

vcoolio

Well-known Member
Joined
Jun 29, 2014
Messages
1,001
Post deleted as the same answer was already supplied by Tetra.
 
Last edited:

Phuoc

Board Regular
Joined
Apr 29, 2016
Messages
209
Or try:

=A1=MAX(($A$1:$A$222<>MAX($A$1:$A$222))*$A$1:$A$222)

10
9
10
10
 

Aitch

Board Regular
Joined
Jan 27, 2019
Messages
94
Office Version
  1. 2010
Platform
  1. Windows
Great!

How do I use this with an ArrayFormula so it checks for the highest in blocks of 10 down the column?

A1-A10
A11-A20 etc

This doesn't seem to work =ArrayFormula(A2=LARGE($A$2:$A$12,2))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,161
Messages
5,527,156
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top