Drag formula while skipping cells that meet condition, and continue from the same place

[costata]

Hi,

I want to drag a formula down so some of reference number will change each cell as I go done.
But, I want to add certain rule (like if condition) and skip some of the cells, yet continue after from the last cell that met the condition.

For example:

When I drag the formula from B1 down, I want it to show the value "b" in cell B3, and the value "c" in cell B5 so on.


Thanks!

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1	1	a	a
2	2		b
3	1	b	c
4	2		d
5	1	c	e
6	2		f
7	1	d	g
8	2		h
9	1	e	i
10	2		j
11	1	f	k
12	2		l
Summary

Cell Formulas
Range	Formula
B1:B12	B1	=IF(A1=1,INDEX($C$1:$C$12,COUNTIFS(A$1:A1,1)),"")

 

[costata]

Thanks, it works perfectly with the example I've suggested.

 

[Fluff]

You're welcome & thanks for the feedback.