CATEGORY: Excel Formula and Function VERSIONS: All Microsoft Excel Versions

Problem: Creating a new list (List2), containing every 3rd value from List1 (Column A). Solution: Using the INDEX function as follows: =INDEX($A$2:$A$13,(ROW()-2)*3+3) Enter the formula in the first cell of List2, and copy it down. List1___List2 A_______C B_______F C_______I D_______L E F G H I J K L

Screenshot // Retrieving Every nth Value In a Range

Rate this tip 1 2 3 4 5   RATING: 3.05   VIEWS: 10769 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

I need a little help.... Keegan wrote on May 18, 2007 10:27 EST This formula is a bit complicated. Instead of simply giving the answer to a problem, can you break it down into digestable segments so potential users can better understand what each part does? oldchippy wrote on May 18, 2007 17:31 EST [QUOTE=Keegan]This formula is a bit complicated. Instead of simply giving the answer to a problem, can you break it down into digestable segments so potential users can better understand what each part does?[/QUOTE] May be this will help? I've broken parts of the formula down so that you can see how the calculation is formed. [url]http://www.excelforum.com/showthread.php?t=369838[/url] formulae not working spschatat wrote on December 31, 1969 19:00 EST This formulae is not working, i copied exactly the same into the worksheet. Swami

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Microsoft PowerPoint Version 2002 Step by Step Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed) Monte Carlo Methods in Finance Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002 Microsoft Excel Version 2002 Step by Step Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books