Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Max, Min and Average formulas
Hello,
I need to compute the average, maximum and minimum values fore items with identical codes as illustrated below: A B C D E 1 Code Weight Average Max Min 2 K224 100 3 K224 200 4 K224 350 5 K224 450 xxx xxx xxx 6 T412 140 7 T412 220 8 T412 320 xxx xxx xxx 9 Q256 214 10 Q256 320 11 Q256 260 xxx xxx xxx May I know the formula I must key it at cell C2, D2 and E2 before copying down to get the answers? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel 2002 formulas | Excel Worksheet Functions | |||
Excel 2002 AVERAGE Function | Excel Discussion (Misc queries) | |||
Excel 2002 - How to keep the formulas unchanged ? | Excel Discussion (Misc queries) | |||
average function in Excel 2002 | New Users to Excel | |||
Excel 2002 Copying Exact formulas | Excel Discussion (Misc queries) |