macro please please please help

L

Leigh-Ann

product supp1 supp2 supp3 supp4 price supp
coffee 6.25 3.45 9.48 10.65
lamb 12.79 21.45 36.98 22.4
mince 21.12 25.45 22.85 62.45
cheese 45.99 45.89 42.12 43.18
I need a formula that will tell me which price is the
cheapist and insert it in the price colum and which
supplier is the cheapist.

Please please help me. I am on Excel 2002.
 
A

Arvi Laanemets

Hi


Leigh-Ann said:
product supp1 supp2 supp3 supp4 price supp
coffee 6.25 3.45 9.48 10.65
lamb 12.79 21.45 36.98 22.4
mince 21.12 25.45 22.85 62.45
cheese 45.99 45.89 42.12 43.18
I need a formula that will tell me which price is the
cheapist and insert it in the price colum and which
supplier is the cheapist.

As I assume, your data are in range A2:E5 with 1st row as header. And you
want formulas for column F and G.

F2=MIN(B2:E2)
G2=OFFSET($A$1,,MATCH(F2,B2:E2,0))
or
G2=OFFSET($A$1,,F2))

and copy both formulas down


Arvi Laanemets
 
L

Leigh-Ann Botha

Thank you very much for your help. My problem is now a
thing of the past.

Kind Regards
Leigh-Ann Botha
The Regent Hotel
East London
South Africa
 
Top