Using a formula to subtract out a Contact
Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this:
Cell 1: Contact1, Contact2, Contact3
Cell3: Use a formula that subtracts out Cell2's value from Cell1's value, returning the values of only Contact1 and Contact3
Hopefully that all makes sense, and I apologize if this is a simple formula question but I've searched through formula/function helps and past threads and can't seem to locate guidance. Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!