M
mdb2002
I’m trying to find the lowest price for type “D” and the median pric
for type “V” based on the item number by using the two prices. How ca
I do this? Here’s what I have.
Item No. Type Product No. A Price B Price
10001 V 125001 $18.99 $17.99
10001 D 360001 $10.99 $11.98
10001 V 125004 $17.99 $17.99
Item No. Type Product No. A Price B Price
10002 D 360540 $10.99 $12.49
10002 V 125090 $15.98 $14.97
10002 D 36150 $14.98 $19.98
Thank you in advance for your help with this
for type “V” based on the item number by using the two prices. How ca
I do this? Here’s what I have.
Item No. Type Product No. A Price B Price
10001 V 125001 $18.99 $17.99
10001 D 360001 $10.99 $11.98
10001 V 125004 $17.99 $17.99
Item No. Type Product No. A Price B Price
10002 D 360540 $10.99 $12.49
10002 V 125090 $15.98 $14.97
10002 D 36150 $14.98 $19.98
Thank you in advance for your help with this