Hi all,
I am having a little problem with the max function in excel:
I need to insert a formular in column C that will give me the maximum value that corresponds to each of the names in column b using data from column A. For instance the maximum value of "aa" from column A is 437. I need a formular to report the maximum value of aa, bb, cc, ee, dd as shown in column b below.
Column A Column b Column C
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 need to insert a formular in column C that will give me the maximum value that corresponds to each of the names in column b using data from column A. For instance the maximum value of "aa" from column A is 437. I need a formular to report the maximum value of aa, bb, cc, ee, dd as shown in column b below.
Column A Column b Column C
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