ExcelTip.com
ExcelTip.com
Account Icon Account Icon Account Icon
Google Exceltip.com
JOIN OUR NEWSLETTER
  and receive for joining:
Free eBook Learn More!
Free Excel ADD-IN
Free Weekly Excel Tip
4 e-books in cd-rom
F1 Formulas & Functions
F1 Formulas & Functions
F1 EXCEL
F1 eBook (Spanish)
F1 EXCEL
Financial Statements.xls
 

» Retrieving Every nth Value In a Range


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

Retrieving Every nth Value In a Range
Rate this tip
12 34 5
  RATING: 3.05
  VIEWS: 10769

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


Convert PDF Files to Excel


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

VIEW ALL BOOKS