Index/Match Lookup with a merged col
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
|