Finding Maximum values

Status
Not open for further replies.

kayode

New Member
Joined
Mar 26, 2009
Messages
37
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,122,805
Messages
5,598,173
Members
414,217
Latest member
Mystix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top