How can I do this?

[confused man]

Hello all,

I just want to start by thanking everyone on this board for all the
wonderful suggestions you give... you guys are life savers!

OK, now to my question... I have a sheet that looks like this...

A B C D
E
1 Date Stock #1 Stock #2 Stock #3 ..... Stock #20
2 2/1/05 $$ $$ $$ $$
3 2/2/05 $$ $$ $$ $$
4 2/3/05 $$ $$ $$ $$
etc........

I want to set up a sheet inside this workbook that tells me what the highest
price for stock 1,2,3...20 was AND on what date it occured. Is this
possible?

Thank you all,
Confused Man

 

[Bernard Liengme]

For max Stock : (MAX(B:B)
For date: =INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Might be saver to use ranges =INDEX(A2:A42,MATCH(MAX(B2:B42),B2:B42,0))