problem with the tabel

  • Thread starter Thread starter gvilms
  • Start date Start date
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
 
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))
 
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)
 
Back
Top