# Unique List From 2 Columns

L

#### Legacy 436357

##### Guest
Hello,

I have a full list of 5 digit numbers in Column B and an incomplete list of 5 digit numbers in Column A. How can I have a unique list in Column C?

These will be the missing 5 digit numbers.

Can this be done with formulas?

Thank you very much for your help.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### sandy666

##### Well-known Member
it must be a formula?

L

#### Legacy 436357

##### Guest
Not necessarily I just need the result please.

#### sandy666

##### Well-known Member
are you able to use PowerQuery (Get&Transform)?

if so...

Code:
[SIZE=1]// Table1
let
Source = Table.ToColumns(Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),
ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Expand = Table.ExpandListColumn(ToTable, "Column1"),
RemDup = Table.Distinct(Expand),
Filter = Table.SelectRows(RemDup, each ([Column1] <> null))
in
Filter[/SIZE]

L

#### Legacy 436357

##### Guest

I appreciate the help but was hoping for a formula.

Thank you I will try googling it.

#### sandy666

##### Well-known Member
but was hoping for a formula.

that's why I asked if it must be a formula

Have a nice day

#### kvsrinivasamurthy

##### Well-known Member

In column C you need missing numbers of column A.

L

#### Legacy 436357

##### Guest
Yes I just need the unique numbers. There are many matches between columns A and B I just need the ones that don't have a match.

Thank you

#### Richard_at_Excelpers

##### New Member
Yes I just need the unique numbers. There are many matches between columns A and B I just need the ones that don't have a match.

Thank you
Hi,
This is my first post so hopefully I've done this right...

To only show values from Col A that don't appear in Col B, type the following into Cell C1...

=IF(COUNTIF(B:B,A1)=0,A1,"")

...and copy down to the end of column C.

I hope this helps.

L

#### Legacy 436357

##### Guest
This doesn't work sorry.

1,106,304
Messages
5,510,503
Members
408,792
Latest member
S_s_s

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...