Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 +-------------------------------------------------------------------+ Filename: Capture.JPG | Download: http://www.excelbanter.com/attachment.php?attachmentid=884| +-------------------------------------------------------------------+ 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 |
#3
|
|||
|
|||
Problem solved. Thank you sir.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup H&V...or match...index??? | Excel Discussion (Misc queries) | |||
Match or Index or Lookup??? | New Users to Excel | |||
Lookup Index Match?? | Excel Discussion (Misc queries) | |||
Lookup, index, match? | Excel Worksheet Functions | |||
Lookup/match/index | Excel Discussion (Misc queries) |