combining two ranges created using "Unique" into one range

[Peter Davison]

I have a range in Sheet 1 column A that has been achieved using the =Unique function drawing from a list in Column A Sheet 3 (variable length) in the workbook
I also have a range in Column A Sheet 2. (Variable length)
I want the range in Column A Sheet 1 to be a list of both Column A Sheet 3 and Column A Sheet 2 to form one range in Column A Sheet 1
Is this possible still using =Unique?

 

[Fluff]

How about

=LET(a,Sheet2!A2:A1000,b,Sheet3!A2:A1000,ra,ROWS(a),s,SEQUENCE(ra+ROWS(b)),I,IF(s<=ra,INDEX(a,s),INDEX(b,s-ra)),UNIQUE(FILTER(I,I<>0)))

 

[Peter Davison]

Wow that is perfect.
I've never used the let function before
You are a star
Thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.