Compare values in multiple columns in excel

Closed
chris - Mar 18, 2014 at 09:33 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Mar 18, 2014 at 10:32 AM
Hello,
i have multiple columns with numerical values and I need to determine which one is the smallest value by row
is there a function that can help me do that
thank you chris



1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Mar 18, 2014 at 10:32 AM
chris, Good morning.

Suppose you may have a smallest value of a row #6.

Try to use:
L6 --> =MIN(B6:K6)

Is this what you desire?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0