Hi,
i need help regading formula to find out hiest Price of the material Code if
we have 5000 nos of material code and every code have 3 diff prices.

M. code description Plant UOM Price M.code Hieghest Price
101 Pen k1 EA 8.05
101 Pen k2 EA 9.00 101 ??
101 Pen k3 EA 8.05
101 Pen k4 EA 8.03 101 ??
102 Reel k1 EA 53.01
102 Reel k2 EA 58.06
102 Reel k3 EA 55.16 102 ??
103 Rubber k1 EA 81.82
103 Rubber k2 EA 84.00
103 Rubber k3 EA 81.80 103 ??
104 Scale k1 EA 45.75
104 Scale k2 EA 45.70 104 ??

regards
Zafar