Finding 3 lowest values

  • Thread starter Thread starter Laurie
  • Start date Start date
L

Laurie

I'm trying to create a method to find the 3 lowest values
across a row. I'd rather it highlight them (one color or
three is fine) but with the =MIN function I can only get
one value. Does anyone know how to have three values
displayed?

Thanks!
 
Hi Laurie
select the row (lets assume A1:X1) and goto 'Format - Conditional
format'. Enter the following formula
=A1<=SMALL($1:$1,3)
 
Thanks Frank for your help. If you check back...one
other question, lol, how do I transfer that formula to
multiple rows? I'm trying to create a spreadsheet to
track pricing received from vendors, then to show in each
row, which price is the cheapest, no matter which order
the vendors are entered.

Again, thanks for such quick help, I've gotten it to work
on one row, but can't seem to establish more than that.
 
You won't believe it, but I figured it out. Thanks a
bunch, you've saved me alot of time!!!
 
Select all your rows, with A1 the active cell, then enter

=A1<=SMALL(1:1,3)

the use of relative addresses means that XL will adjust the row numbers
for each row in your selection
 
Back
Top