# Slight mod of this formula

#### uberathlete

##### Board Regular
Hi everyone. I asked a question in this post

http://www.mrexcel.com/board2/viewtopic.php?t=282245&highlight=

and Krishnakumar at the bottom of the page suggested a formula. I'm using it but now I'd like to modify it slightly so that if symbols have the same volume for the same date, the symbol to be returned is the first symbol with that volume in the table. So, say AAA and BBB have the same volume on December 13, 2000, the symbol to be returned in cell H5 is AAA because it comes before BBB in the horizontal order of symbols.

Any help would be greatly appreciated. Thanks!

Here's the table using Excel Jeanie:

Excel Workbook
GHIJKLMN
1Sum of Volume
2DateSymbol with largest valueDateAAABBBCCCGrand Total
312/11/200012/11/200046854
412/12/200012/12/200011
512/13/200012/13/20002451195
6
Sheet1

and Krishnakumar's suggested formula:

H3:

=INDEX(\$K\$2:\$M\$2,MATCH(MAX(INDEX(\$K\$3:\$M\$5,MATCH(G3,\$J\$3:\$J\$5,0),0)),INDEX(\$K\$3:\$M\$5,MATCH(G3,\$J\$3:\$J\$5,0),0),0))

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

#### uberathlete

##### Board Regular
Just wondering if a macro would work for this too?

#### barry houdini

##### MrExcel MVP
Doesn't Kris' formula do what you want already?

Having said that ......try this formula in H3 copied down

=INDEX(K\$2:M\$2,MATCH(MAX(K3:M3),K3:M3,0))

Replies
2
Views
192
Replies
1
Views
347
Replies
2
Views
224
Replies
3
Views
151
Replies
0
Views
122

1,191,226
Messages
5,985,373
Members
439,961
Latest member
drose1105

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

### Which adblocker are you using?

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

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