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

Hi Biff,

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

Helena


"T. Valko" a écrit dans le message de news:
...
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)


--
Biff
Microsoft Excel MVP


"Helena" wrote in message
...
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

Thanks Bob,

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

Helena


"Bob Phillips" a écrit dans le message de news:
...
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)



"Helena" wrote in message
...
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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Helena" wrote in message
...
Hi Biff,

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

Helena


"T. Valko" a écrit dans le message de news:
...
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)


--
Biff
Microsoft Excel MVP


"Helena" wrote in message
...
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