Compare two columns, only return the differences.

[jschomisch]

Columns F and G are pulling project numbers from two different programs. Column G has the project number and the title, while column F only has the project number. We are not allowed to use macros on our work computers, I want column A to have a list of project numbers that are in F but not in G. My difficulty is the title in with the project numbers in G (and they aren't always at the beginning), so I can't get MATCH or INDEX to work like I want them too.

 

[kvsrinivasamurthy]

There is no data in column G

 

[Fluff]

How about like

=FILTER(E2:E10,COUNTIFS(F2:F10,"*"&E2:E10&"*")=0)

 

[jschomisch]

How about like

=FILTER(E2:E10,COUNTIFS(F2:F10,"*"&E2:E10&"*")=0)

This was perfect, thank you very much Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[6StringJazzer]

There is no data in column G

OP description was for F & G but actual problem per screenshot was the same thing in E & F, as solved by Fluff.

 

[jschomisch]

How about like

=FILTER(E2:E10,COUNTIFS(F2:F10,"*"&E2:E10&"*")=0)

Hi Fluff, quick question - will it sometimes return #CALC! if there's no information found? Even if I wrote an IFNA around your equation?

 

[Fluff]

How about

=FILTER(E2:E10,COUNTIFS(F2:F10,"*"&E2:E10&"*")=0,"")

 

[jschomisch]

How about

=FILTER(E2:E10,COUNTIFS(F2:F10,"*"&E2:E10&"*")=0,"")

Hi Fluff, that equation works most of the time, but sometimes I'm getting back #CALC! - is that because there is no information to calculate? I have wrapped your equation within an IFNA(your equation),"")

 

[Fluff]

Using ifna won't make any difference, as the formula is returning #calc, not #n/a.
The formula in post#8 should prevent the #calc error.