Compare two columns and show only the difference in the third column

Seasons Greetings!

I'll cut to the chase, I have Col F and Col G with strings that I would like to compare and then have Col H display the difference.

Example:
Col F has :KIWI,MEDC,NETB,PTXl,SAL,TAX,WCMO,WDPD,WEFD,WEPD
Col G has :KIWI,MEDC,NETB,PTXl,SAL,SIC,TAX,WCMO,WDPD,WEFD,WEPD
Col H would show: SIC

I want a formula that will look at the two and display the difference in the next column Col H

The difference in this example, would be the SIC code in col G

Any ideas?

Try PowerQuery (Get&Transform)
in short: merge two tables (in this case two single columns) use conditional column, remove two source columns then remove null value from conditional column and load result table wherever you want

Thanks for the suggestion, however my solution needs to be in a cell formula, as this will actually go in a google sheet.

I have searched the web for Google scripts that could do a compare but slim pickings for a workable result.

so you should ask moderator to move this thread to this part of forum: For Other Platforms(Mac, Google Docs, Mobile OS etc)

edit: use Report Post from your first post

Thanks, i still think this is relevant to sit where it is.

After all it is a MS Excel formula that I am looking for.
The endgame of where that formula goes should not really have an impact.
This is meant in the nicest possible way

not really but it's up to you
have a nice day

.
This macro highlights the differences between both columns, within each column. It does not use a third column for notification.
Will this do ?

Please Login or Register  to view this content.

https://stackoverflow.com/questions/...ll-differences

Thanks for the reply.

Sorry, I should have stated my question differently.
I need a formula to compare two cells, rather than two columns.

The formula needs to (for example) compare the string in F1 against the string in H1 and display in I1 what is missing. In this case, it would be the SIC code.

I have been playing around with the following formula, but i don't want to have it display a predefined text, I would like to have the result be of the missing string.

Please Login or Register  to view this content.

We seem like we are on the same wave length, do you think you could help either change my formula or write a new one?

.

Please Login or Register  to view this content.

Paste in I1 and drag down.

Thanks for the reply.

I am wanting to have only the missing value in Col I, not the entire string.

Thanks for the input, i can't have it as a macro due to how this sheet will be used.
I need it to be in a formula or javascript if there is not formula option.