Carry-forward: Tab to Tab?

macropod · #1 01-30-2011, 01:07 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Forward without forwarding formatting	whatever61	Outlook	0	12-14-2010 08:08 AM
forward message to outlook category	knoutam	Outlook	1	11-07-2010 02:13 PM
Can I carry Outlook 2007 with me on a usb stick?	Hansio	Outlook	2	09-09-2010 01:29 PM
Auto-Forward Read Reply	timcar1	Outlook	0	10-13-2009 09:33 PM
Auto forward return receipt to Requestor	sarav@msoutlook	Outlook	0	12-09-2008 06:34 AM