SOLVED

FORMULAS AND FUNCTIONS

%3CLINGO-SUB%20id%3D%22lingo-sub-3206149%22%20slang%3D%22en-US%22%3EFORMULAS%20AND%20FUNCTIONS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206149%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20I%20WANT%20TO%20TAKE%20A%20LIST%20OF%20THINGS%20IN%20COLUMN%20A%20AND%20SUBTRACT%20FROM%20THEM%20THE%20LIST%20OF%20THINGS%20IN%20COLUMN%20B%20AND%20PUT%20THE%20LIST%20IN%20COLUMN%20C.%20THE%20THINGS%20IN%20THE%20LISTS%20ARE%20NOT%20NUMBERS%20THEY%20ARE%20ITEMS.%20HELP!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3206149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206189%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULAS%20AND%20FUNCTIONS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316077%22%20target%3D%22_blank%22%3E%40NALINLE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20may%20recommend%2C%20provide%20more%20information.%3C%2FP%3E%3CP%3EYou'll%20get%20a%20quicker%20and%20more%20accurate%20answer%2C%20and%20those%20who%20want%20to%20help%20don't%20have%20to%20invest%20time%20guessing%20the%20problem.%3C%2FP%3E%3CP%3EWhat%20I%20recommend%3A%20Always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20project%20step%20by%20step%2C%20or%20add%20photos%20with%20the%20appropriate%20description.%3C%2FP%3E%3CP%3EDon't%20forget%20that%20not%20every%20Excel%20user%20has%20a%20clue%20about%20every%20job%20and%20that%20what%20you%20see%20he%20can't%20see.%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206325%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULAS%20AND%20FUNCTIONS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206325%22%20slang%3D%22en-US%22%3ECan%20you%20use%20SUBSTITUTE()%3F%20so%20%3DSUBSTITUTE(A1%2CB1%2C%22%22)%20and%20up%20to%20you%20if%20you%20want%20to%20replace%20every%20case%20or%20add%20a%20parameter%20like%201%20to%20only%20replace%20the%20first%20case.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206438%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULAS%20AND%20FUNCTIONS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316077%22%20target%3D%22_blank%22%3E%40NALINLE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DFILTER(%24A%242%3A%24A%2415%2CCOUNTIF(%24B%242%3A%24B%2415%2C%24A%242%3A%24A%2415)%3D0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EDo%20you%20want%20to%20return%20items%20that%20are%20in%20column%20A%20and%20not%20in%20column%20B%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

HI I WANT TO TAKE A LIST OF THINGS IN COLUMN A AND SUBTRACT FROM THEM THE LIST OF THINGS IN COLUMN B AND PUT THE LIST IN COLUMN C. THE THINGS IN THE LISTS ARE NOT NUMBERS THEY ARE ITEMS. HELP!!

5 Replies

@NALINLE 

With your permission, if I may recommend, provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

What I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and that what you see he can't see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

Can you use SUBSTITUTE()? so =SUBSTITUTE(A1,B1,"") and up to you if you want to replace every case or add a parameter like 1 to only replace the first case.
best response confirmed by mtarler (Trusted Contributor)
Solution

@NALINLE 

=FILTER($A$2:$A$15,COUNTIF($B$2:$B$15,$A$2:$A$15)=0)

Do you want to return items that are in column A and not in column B? 

YES! THANK YOU!
OK SO ILL TELL YOU EXACTLY WHAT IM DOING. sorry im not screaming. i have a list of shipping containers that are in my companies yard today. and a list that were in the yard yestarday. since the list was made yesterday some came and some left, which results in the list today. however i need to know exactly which spacific ones came and which ones left. so i need to subtract todays list from yesterdays list, then i need to subtract yesterdays list from todays list