Hi!

Maybe something like this:

=SMALL(A$1:A$9,ROWS($1:1))

Copied down as needed.

Biff

"BuckyGeorge" wrote in message
...
I have data that is 22 cells apart which are related which has data between
them which are 22 cells apart also, i.e. 1's are related, 2's are related
data, etc.
I have currently:
1
2
3
1
2
3
1
2
3
I want:
1
1
1
2
2
2
3
3
3
etc.

Thanks