Combine unique and sequence function to create a list of repeating numbers

[sabin348]

I have a list of of numbers where I'm using the unique function to pull a clean list. However, instead of just a column of unique values, I want them to repeat once.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	123		123
3	234		123
4	234		234
5	234		234
6	345		345
7	456		345
8	345		456
9			456
Data

Cell Formulas
Range	Formula
C2:C9	C2	=TOCOL(IF(SEQUENCE(,2),UNIQUE(A2:A8)))
Dynamic array formulas.

 

[sabin348]

Works Perfectly! Thx

 

[Fluff]

You're welcome & thanks for the feedback.