| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest Value
Hi,
If sheet1 has some data which is each material code has diff supplier rate now I want highest rate on sheet 2 against material code how I can do that with the formula? Example sheet1 M.code S.rate 1002 105 104 106 1003 110 102 1004 125 130 sheet2 M.code S.rate 1002 106 1003 110 1004 130 Regards Zafar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Next highest Value | Excel Worksheet Functions | |||
| Highest, Second Highest , Third Highest and so on | Excel Discussion (Misc queries) | |||
| Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| second highest value | Excel Discussion (Misc queries) | |||
Threaded Mode
