Autofill Help

themev

Board Regular
Joined
Aug 13, 2007
Messages
80
I have a sheet with many, many groups of data. The first has information in A9:N12. The next group is in A15:N18 and so on and so forth.

I am interested in just pulling certain data from each group into a list on the side - M9, M15, M21, M27 etc. (in that same pattern) and N10, N16, N22, N28 etc. - Is there a quick way to do this? Auto-fill seems to randomly choose cells when I drag down...
Thanks.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,672
Office Version
  1. 2016
Platform
  1. Windows
Try using a pivot table as you can highlight all the ranges in your sheet and it will ignore blank rows, that should give you the desired data to then filter on.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,165
Office Version
  1. 365
Platform
  1. Windows
See if this helps. It extracts the 2nd value from each block. To get, say, the 3rd value change the 2 at the end of the formula to a 3. The 6 in the formula represents the number of rows from the start of one block to the start of the next block. The formula is just copied down.

Excel Workbook
ABC
8
9ab
10bf
11cj
12d
13
14
15e
16f
17g
18h
19
20
21i
22j
23k
24l
25
INDEX
 

Watch MrExcel Video

Forum statistics

Threads
1,108,609
Messages
5,523,885
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top