Price comparison...

J

John84

Hi Guys,

Here's my problem....

I have two columns with prices from two different sources. On a thir
column, is where I would like the price from the cheaper source to be
Is there a way i can do this without having to do it manually?

I hope I was specific enough for you guys. Thanks in advance
 
N

Norman Jones

Hi John,

Assume your two price columns are columns B and C.
Assume your first price row is row 2.

In cell D2 enter the formula:

=min(B2:C2)

Now drag (or copy) down the formula in D2 for as many rows as you need.

Adjust B, C and the row number to suit your situation.
 
Top