I am trying to figure out the correct formula for returning, in the example below, minimum and maximum sell price. For instance, I want to return the MIN/MAX sell price for A (MIN 50, MAX 75), for B, for C, etc. I just cannot figure out the correct syntax. Can someone please help?
Code:
EXAMPLE:
Product.......Sell Price........MIN.........MAX
A................75
C................75
B................200
C................50
A................50
B................25
B................100
C................25
A................150