problem with the tabel

G

gvilms

hello

Here is the problem;
I have names in cells B1:M1
and values in B2:M2

In cell N2 i want to see the smallest value and in O2 who has the
smallest value

thank you
 
P

Paul

gvilms > said:
hello

Here is the problem;
I have names in cells B1:M1
and values in B2:M2

In cell N2 i want to see the smallest value and in O2 who has the
smallest value
Click to expand...

In N2 put
=MIN(B2:M2)

In N1 put
=INDEX(B1:M1,MATCH(N2,B2:M2,0))
 
B

Bob Phillips

N2: =MIN(B2:M2)
O2: =INDEX(B1:M1,MATCH(N2,B2:M2,0),1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top