# Maximum Value Problem

#### kayode

##### New Member
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

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
TRY THIS

Excel Workbook
ABCDE
1aa34aa437
2bb41bb524
3cc49cc364
4cc59ee303
5bb71dd211
6aa85
7aa102
8cc122
9bb146
10dd175
11dd211
12ee253
13ee303
14cc364
15aa437
16bb524
Sheet2

USE control+shift+enter

Or

Excel Workbook
ABCD
1ABCD
2aa34aa437
3bb41bb524
4cc49cc364
5cc59ee303
6bb71dd211
7aa85
8aa102
9cc122
10bb146
11dd175
12dd211
13ee253
14ee303
15cc364
16aa437
17bb524
Sheet2

Thanks a lot!. Works perfectly!

Just discovered that both formulars work perfect for small ranges but break down for large ranges say A1:A1000.I have got quite a large volume of data. I tried the unbounded reference A:A but it didnt work. Any help with this?

Replies
9
Views
248
Replies
13
Views
298
Replies
7
Views
905
Replies
0
Views
109
Replies
3
Views
213

1,206,947
Messages
6,075,798
Members
446,158
Latest member
octagonalowl

### 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?

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