Home > Answers > What formula can I use in Excel 2007 to create one list twa1310542573

What formula can I use in Excel 2007 to create one list from another?

Please see the image for a visual representation of this. The left-hand list contains the information I want, at regular intervals of 3 rows. I want to copy only this information into a list on the right, which would no longer be separated by rows. I've already tried 2 things: in C1, C2 and C3 putting =A1, =A4 and =A7, but when I highlight and pull down to copy the formula, the formula doesn't continue upwards (i.e. A10, A13 etc.) so the results are inaccurate. I've also tried =A3, =A(3+5), but it doesn't like the brackets at all. Although the question is quite complex, what I am asking is actually very simple. Does anyone have a solution?

الإجابات (1)

Robert Derbyshire

Someone has actually resolved this for me: B1 =INDIRECT("A"&ROWS($1:1)*3-2) copy down column

21:45, 13 July 2011

يجب عليك تسجيل الدخول لنشر مشاركاتك في المناقشات.


معاجم متميزة

Meilleurs Films

الفئة: ترفيه   2 0 بنود

Top 10 Most Popular Social Networks

الفئة: Business   1 11 بنود

Home and Office Removal

الفئة: غير ذلك   1 3 بنود

The World's Most Valuable Brands

الفئة: غير ذلك   1 10 بنود

HealthyWealthyTips- Wheezing or Asthma Remedies!

الفئة: Health   1 10 بنود

Engineering Branches

الفئة: هندسة   1 12 بنود