How to use UNIQUE, SORT and FILTER all together?

[helpneeded2]

I can seem to get UNIQUE, SORT and FILTER all working together.

Here's some example data:

123	John	Dogs
444	Mary	Cats
56	Sue	Birds

This is a simplified example table, and an important note is that my actual table will contain various blank rows in between the rows with data.

I want to sort the table by Column B, and filter the table for data in Column A where the value must be <>"", and then apply Unique, as there there may be multiple entries of the same number in Column A.

How can this be achieved. Everything I try results in a SPILL error?

 

[Eric W]

Try:

Book2
	A	B	C	D	E	F	G
1	123	Mary	Dogs		444	John	Cats
2	444	John	Cats		123	Mary	Dogs
3	56	Sue	Birds		56	Sue	Birds
4	123	Mary	Dogs
5
Sheet15

Cell Formulas
Range	Formula
E1:G3	E1	=SORT(UNIQUE(FILTER(A1:C10,A1:A10<>"")),2)
Dynamic array formulas.

SPILL means the resultant array overlaps some cells that have data in them. Try clearing everything out to the bottom and right and maybe your formula will work.

 

[helpneeded2]

Thanks Eric about pointing out the over lapping data... I am very new to these functions, and now realize I had columns of data in the way of where the filter range was trying to display the data.

 

[Eric W]

Happy to help! Thanks for the update.