Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 5
Default 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
Attached Images
 
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default 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   Report Post  
Junior Member
 
Posts: 5
Thumbs up

Problem solved. Thank you sir.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup H&V...or match...index??? Kevin W[_2_] Excel Discussion (Misc queries) 6 April 1st 10 02:42 PM
Match or Index or Lookup??? Qld Help.. New Users to Excel 4 July 21st 08 10:45 PM
Lookup Index Match?? l33b3z Excel Discussion (Misc queries) 0 July 16th 08 12:28 PM
Lookup, index, match? Kikuchisawa Excel Worksheet Functions 1 March 10th 08 10:14 PM
Lookup/match/index Jules Excel Discussion (Misc queries) 1 July 5th 06 05:02 PM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"