# Thread: Unique List From 2 Columns Thanks: 0 Likes: 0

1. ## Re: Unique List From 2 Columns

...if you have column headings, you may need to use...
=IF(COUNTIF(B:B,A=0,A2,"")

Basically, this will only show values in Column C if they don't appear in Col C.  Reply With Quote

2. ## Re: Unique List From 2 Columns

 A B C D 32 11 11 45 12 34 12 34 51 51 51 32
Column A data A2:A5
Column B data B2:B7
ARRAY Formula in D2 then copied down

Code:
`=IFERROR(INDEX(\$B:\$B,SMALL(IF((COUNTIF(\$D\$1:\$D1,\$B\$2:\$B\$7)=0)*COUNTIF(\$A\$2:\$A\$4,\$B\$2:\$B\$7)=0),ROW(\$B\$2:\$B\$7),""),ROWS(\$D\$2:\$D2))),"")`
How ARRAY formula is entered

Paste Formula in the cell.
Press F2
Hold Shift+ Ctrl Keys and hit Enter key.
Now the formula is surrounded by {} by excel.  Reply With Quote

3. ## Re: Unique List From 2 Columns

Formula given in previous post does not work properly.
Here is the revised formula.

Code:
`=IFERROR(INDEX(\$B:\$B,SMALL(IF((COUNTIF(\$D\$1:\$D1,\$B\$2:\$B\$7)=0)*COUNTIF(\$A\$2:\$A\$4,\$B\$2:\$B\$7)=0),ROW(\$B\$2:\$B\$7),""),1)),"")`  Reply With Quote

4. ## Re: Unique List From 2 Columns

If numbers in both list are required.

 A B C D 32 11 11 45 12 34 12 34 51 51 45 51 32
ARRAY formula in D2

Code:
`=IFERROR(INDEX(\$B:\$B,SMALL(IF((COUNTIF(\$D\$1:\$D1,\$B\$2:\$B\$7)=0)*(COUNTIF(\$A\$2:\$A\$4,\$B\$2:\$B\$7)=0),ROW(\$B\$2:\$B\$7),""),1)),IFERROR(INDEX(\$A:\$A,SMALL(IF((COUNTIF(\$D\$1:\$D1,\$A\$2:\$A\$4)=0)*(COUNTIF(\$B\$2:\$B\$7,\$A\$2:\$A\$4)=0),ROW(\$A\$2:\$A\$4),""),1)),""))`  Reply With Quote

## User Tag List

#### Tags for this Thread

column, digit, list, numbers, unique #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•