pls see the atatchment. i have copied your formula, i want the maximum sales price per unit.
for eg, when i select a particular item no. all shipments of that item is displayed. it shows the per unit sales price and cost price for all shipments. i want the maximum and minimum price of that item.