problem with the tabel

[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

 

[Paul]

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

In N2 put
=MIN(B2:M2)

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

 

[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)