Autofill Help

[themev]

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.

 

[Trevor G]

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]

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
	A	B	C
8
9	a		b
10	b		f
11	c		j
12	d
13
14
15	e
16	f
17	g
18	h
19
20
21	i
22	j
23	k
24	l
25
INDEX