list of unique elements

[Helena]

Hello,

How can I get by formula, in a column, the list of unique elements in a
matrix of x columns x rows.
For example:
A1: A5 ={1,2,3,4,5}
B1: B5 = {0,4,5,1,0}
C1: C5 = {5,4,0,4,0}
Desired outcomes in
E1: E15 = {2,3,"","","","","","","","","","","","",""}

Thank you in advance for the help that you will help me.
Helena

 

[Bob Phillips]

If used as a 5x3 block-array formula, this returns the array but not in that
order

=IF(COUNTIF($A$1:$C$5,$A$1:$C$5)=1,$A$1:$C$5,"")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[T. Valko]

This array formula** will extract the values (if any) in ascending order:

Entered in E1 and copied down to E15.

rng = A1:C5

=IF(ROWS(E$1:E1)<=SUM(--(COUNTIF(rng,rng)=1)),SMALL(IF(COUNTIF(rng,rng)=1,rng),ROWS(E$1:E1)),"")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Helena]

Hi Biff,

Just perfect !
Congratulations, and thank you for your help.

Helena

 

[Helena]

Thanks Bob,

I consider this solution to ac ...
But, i opted for the proposal from Biff who responded perfectly to the
original question.

Helena

 

[T. Valko]

You're welcome. Thanks for the feedback!