IF function- Return Data from Separate Column

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

 

[Bernie Deitrick]

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

 

[JRQ]

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]

I THINK I FIGURED IT OUTT!! THANK YOU Bernie for the big tip!

=IF(A3=A2,MIN(B3<B2,0,B2),B2)

 

[Bernie Deitrick]

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

 

[JRQ]

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