» Repeat entries in a column
CATEGORY - Excel Formula
VERSION - All Microsoft Excel Versions
If you have entries like these in a column which need to be repeated a certain number of times (for e.g. 4 times), try the formula given below the table -
The formula is =INDEX($A$2:$A$1000,CEILING(ROW(A1)/4,1))
Here the ceiling is shown as 4 because we want the value to be repeated 4 times.
This is how it will appear -
Book Store:
Recommended Books:
- PowerPoint® 2002 For Dummies®
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Marketing Plans That Work, Targeting Growth and Profitability
- Financial Reporting and Analysis (2nd Edition)
- Personal Finance for Dummies
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
