Slight mod of this formula

[uberathlete]

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
	G	H	I	J	K	L	M	N
1				Sum of Volume
2	Date	Symbol with largest value		Date	AAA	BBB	CCC	Grand Total
3	12/11/2000			12/11/2000	46		8	54
4	12/12/2000			12/12/2000		1		1
5	12/13/2000			12/13/2000	24	5	11	95
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))

 

[uberathlete]

Just wondering if a macro would work for this too?

 

[barry houdini]

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))