IF function- Return Data from Separate Column

  • Thread starter Thread starter JRQ
  • Start date Start date
J

JRQ

I thought I had ran across a thread similar to this a few days ago but I
can not find it.

I think I'm on the right track and that my formula should be nested but
I can't get it right.

I've been trying to modify the following formual in A2
if(A3=A2,if(B3<B2,B3,B2),A2) - it doesn't work.

If the values in Column A are =
then return the lowest price in Column B for that item.

Col A
dog
cat
bat
bat
bat
ball
ball

Col B
$1.50
$1.75
$2.00
$1.25
$1.19
$2.00
$2.20

Can y'all help me?
 
I think what you're after is this, entered with Ctrl-Shift-Enter in
cell C2

=MIN(IF($A$2:$A$10=A2,$B$2:$B$10))

Change the 10 in both spots to reflect your actual range. This
formula will return the minimum price listed in column B for the item
in column A.

HTH,
Bernie
 
we're almost there - I need the minimum price for only the items that
are the same or = in Column A

so I guess there's one more little step
 
JRQ,

This formula will fail when you have more than two similar items in
column A, or if column A isn't sorted to keep similar items together.

HTH,
Bernie
 
Yes - my items are all sorted by column a and then descending by Column
B so that the cheapest price is at the end of the product groups
 
Back
Top