Thread: [Solved] Carry-forward: Tab to Tab?
View Single Post
 
Old 01-30-2011, 01:07 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Mark,

The inner workings of the INDEX and MATCH fuunctions are explained in Excel's Help file. FWIW:
• 1E+306 is a number expressed in scientific notation. It's actually the largest numnber Excel is capable of storing.
• MATCH(1E+306,Sheet1!A:A,1) tells Excel to use 1E+306 to find the highest numbered (ie last used) row in column A on Sheet1.
• INDEX(Sheet1!A:A,MATCH(1E+306,Sheet1!A:A,1)) tells Excel to return the value of the cell referenced by the MATCH function.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote