Hi all,
I am having a little problem with the max function in excel. I have tried to explain the problem as shown below:
I need to insert a formular in column D that will give me the maximum value that corresponds to each of the names in column C using data from column B. For instance the maximum value of "aa" from column B is 437. I need a formular to report the maximum values of aa, bb, cc, ee, dd as shown in column C below.
I will be glad to get help from you. Thanks.
A B C D
aa 34 aa
bb 41 bb
cc 49 cc
cc 59 ee
bb 71 dd
aa 85
aa 102
cc 122
bb 146
dd 175
dd 211
ee 253
ee 303
cc 364
aa 437
bb 524
I am having a little problem with the max function in excel. I have tried to explain the problem as shown below:
I need to insert a formular in column D that will give me the maximum value that corresponds to each of the names in column C using data from column B. For instance the maximum value of "aa" from column B is 437. I need a formular to report the maximum values of aa, bb, cc, ee, dd as shown in column C below.
I will be glad to get help from you. Thanks.
A B C D
aa 34 aa
bb 41 bb
cc 49 cc
cc 59 ee
bb 71 dd
aa 85
aa 102
cc 122
bb 146
dd 175
dd 211
ee 253
ee 303
cc 364
aa 437
bb 524