SPECIFIC ARRAY COLLATE

[Shakeable_Drip]

Hello,

I have a filter array that I'd like to collate like the below, is this possible? I don't want to collate by UNIQUE, I want to "remove" the next duplicates in the set. Thanks for your time!

data result
2 2
1 1
1 2
1 1
1
1
2
2
1
1

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	2	2
3	1	1
4	1	2
5	1	1
6	1
7	2
8	2
9	1
10	1
Master

Cell Formulas
Range	Formula
B2:B5	B2	=FILTER(A2:A10,A1:A9<>A2:A10)
Dynamic array formulas.

 

[JamesCanale]

Not sure that I got you....

Book1
	A	B	C
1
2	2		2
3	1		1
4	1		3
5	3		1
6	1		2
7	1		1
8	2
9	2
10	1
11	1
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=LET(a,A2:A11,b,OFFSET(a,1,0)<>a,FILTER(a,b))
Dynamic array formulas.

 

[Shakeable_Drip]

How about

Fluff.xlsm
	A	B
1
2	2	2
3	1	1
4	1	2
5	1	1
6	1
7	2
8	2
9	1
10	1
Master

Cell Formulas
Range	Formula
B2:B5	B2	=FILTER(A2:A10,A1:A9<>A2:A10)
Dynamic array formulas.

oh facepal

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Shakeable_Drip]

the first filter answer didnt work, it looked like it would. The Let/offset was what I was after. thanks!

 

[Fluff]

In what way didn't it work?

 

[Joe4]

In what way didn't it work?

It worked for me.
Perhaps they made an error in adjusting the formula for their exact range.

 

[Shakeable_Drip]

How about

Fluff.xlsm
	A	B
1
2	2	2
3	1	1
4	1	2
5	1	1
6	1
7	2
8	2
9	1
10	1
Master

Cell Formulas
Range	Formula
B2:B5	B2	=FILTER(A2:A10,A1:A9<>A2:A10)
Dynamic array formulas.

sorry, I shouldnt have said it didnt work, more as I dont know how to make it work. the Filter's include is from A1-A9 but those possitions fall outside my array spill. when I select my array to use in equations it reads as A2#. I tried to make it work with out the A1 offset and I couldnt figure it out. Selectins A1 and the bottom off the spill reads as A11 and when more is added to the array those get missed

 

[Fluff]

It would have helped if you had given us ALL the details at the start.