TOCOL and Unique on non adjacent ranges of data

[Mark McInerney]

Hi All - Thanks in advance for looking at this - appreciated.

I have two ranges of data on separate sheets - a1:a2500 on one sheet and a1:a7500 on another sheet - is it possible to combine a TOCOL and Unique formula that will return the unique values from both columns?

Thanks - Mark.

 

[Fluff]

How about

=UNIQUE(TOCOL(VSTACK(Sheet1!A1:A2500,Sheet2!A1:A7500),1))

 

[Mark McInerney]

Hi Fluff (Thanks - you've always been supportive on this forum ),

Is it possible to link the range reference to the last cell in that range rather than specifically referencing a set range?

 

[Dave Patton]

=UNIQUE(VSTACK(SheetA!A1:A2500,SheetB!A1:A7500))

 

[Fluff]

Is it possible to link the range reference to the last cell in that range rather than specifically referencing a set range?

As long as the the other cells are empty there is no need as the tocol will remove any empty cells.

 

[Mark McInerney]

Super - Thanks Fluff - really appreciate it - Thank You.

 

[Fluff]

You're welcome & thanks for the feedback.