How can I do this?

  • Thread starter Thread starter confused man
  • Start date Start date
C

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