Index/Match Lookup with a merged col

[JoshBrunz]

This should be a fun one...

I have a spread sheet of team scores. col a is the date of the game an
is 6 cells merged up and down. the 6 cells next to it in col b ar
names. cols c-o are stats and scores for each name. the dates are not i
order. im trying to find the newest game date and display all 6 column
next to it (b-o) in another section.

im using:

=CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0)))

to return the address of the newest game. how can i get the 6 column
next to it?

attached is a screenshot of one dates number

+-------------------------------------------------------------------
|Filename: Capture.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=884
+-------------------------------------------------------------------

 

[GS]

This should be a fun one...

I have a spread sheet of team scores. col a is the date of the game
and is 6 cells merged up and down. the 6 cells next to it in col b
are names. cols c-o are stats and scores for each name. the dates are
not in order. im trying to find the newest game date and display all
6 columns next to it (b-o) in another section.

im using:

=CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0)))

to return the address of the newest game. how can i get the 6 columns
next to it?

attached is a screenshot of one dates numbers


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

I didn't look at your file! You can use the OFFSET() function and
specify the number of rows/cols to be included.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[JoshBrunz]

Problem solved. Thank you sir

+-------------------------------------------------------------------
+-------------------------------------------------------------------