| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for hiest rate
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a daily rate when the rate could be fixed or variable | New Users to Excel | |||
| how do i convert a flat rate into a reducing rate? | Excel Worksheet Functions | |||
| Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
| APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Threaded Mode
