M
Mr. Low
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
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