Find unique value from 2 columns

[KIM Chanthan]

Hi,

I have one question whether how can I find unique value from 2 columns?
Please find attached file for more detail.

Thank,
Chanthan

 

[Nebu]

Hi:

Use the following array formula:-

=IFERROR(IFERROR(INDEX($A$2:$A$6, MATCH(0, COUNTIF(E$1:$E1, $A$2:$A$6), 0)), INDEX($B$2:$B$5, MATCH(0, COUNTIF($E$1:E1, $B$2:$B$5), 0))), "")

Execute by pressing control+shift+enter keys.

Thanks

 

[bosco_yip]

Hi,

Adding &"" inside your formula as per highlighted :

=IFERROR(IFERROR(INDEX($A$2:$A$9,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$9&""),0)),INDEX($B$2:$B$9, MATCH(0,COUNTIF($D$1:D1,$B$2:$B$9&""),0))),"")

This is an array formula confirm enter with Ctrl+Shift+Enter

Regards
Bosco

 

[KIM Chanthan]

Thank, but if I expand my selection to the blank area, 0 is still appear.

Hi:

Use the following array formula:-

=IFERROR(IFERROR(INDEX($A$2:$A$6, MATCH(0, COUNTIF(E$1:$E1, $A$2:$A$6), 0)), INDEX($B$2:$B$5, MATCH(0, COUNTIF($E$1:E1, $B$2:$B$5), 0))), "")

Execute by pressing control+shift+enter keys.

Thanks

 

[KIM Chanthan]

It work perfectly. Thanks alot

Hi,

Adding &"" inside your formula as per highlighted :

=IFERROR(IFERROR(INDEX($A$2:$A$9,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$9&""),0)),INDEX($B$2:$B$9, MATCH(0,COUNTIF($D$1:D1,$B$2:$B$9&""),0))),"")

This is an array formula confirm enter with Ctrl+Shift+Enter

Regards
Bosco[/quote

 

[KIM Chanthan]

Hi,

Adding &"" inside your formula as per highlighted :

=IFERROR(IFERROR(INDEX($A$2:$A$9,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$9&""),0)),INDEX($B$2:$B$9, MATCH(0,COUNTIF($D$1:D1,$B$2:$B$9&""),0))),"")

This is an array formula confirm enter with Ctrl+Shift+Enter

Regards
Bosco

I

It work perfectly. Thanks alot

Your formula works well, but unfortunately it could not run with huge data like thousand rows. Do you have any way to help on that?

Thank again.

 

[bines53]

Hi KIM,

What size of unique value,you come ?
Which version of Excel you have ?

David