if

%3CLINGO-SUB%20id%3D%22lingo-sub-1974605%22%20slang%3D%22en-US%22%3Eif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1974605%22%20slang%3D%22en-US%22%3E%3CP%3EOk%20so%20need%20a%20little%20bit%20of%20help%20with%20a%20what%20if%20formula.%20ive%20attached%20a%20file%20that%20includes%20phone%20number.Phone%20number%20column%20one%20is%20associated%20with%20the%20column%20labeled%20%22DNC%22%20which%20has%20a%20value%20of%20either%20%22Y%22%20or%20%22N%22%3C%2FP%3E%3CP%3ESo%20i%20want%20to%20be%20able%20to%20delete%20the%20phone%20number%26nbsp%3B%20in%20the%20column%20one%20which%20its%20associated%20DNC%20column%26nbsp%3B%20if%20labeled%20%22y%22%20and%20leave%20it%20alone%20if%20labeled%20%22N%22.%20thanks%20in%20advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1974605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1974672%22%20slang%3D%22en-US%22%3ERe%3A%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1974672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F897026%22%20target%3D%22_blank%22%3E%40codyhtch40195%3C%2FA%3E%26nbsp%3BRather%20than%20deleting%20data%2C%20why%20not%20clean-up%20the%20table%20a%20bit%20and%20put%20a%20filter%20on%20the%20DNC%20column%3F%20See%20attached%20file.%3C%2FP%3E%3CP%3EOr%2C%20if%20you%20are%20a%20MS365%20subscriber%2C%20your%20Excel%20version%20perhaps%20supports%20the%20FILTER%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Ok so need a little bit of help with a what if formula. ive attached a file that includes phone number.Phone number column one is associated with the column labeled "DNC" which has a value of either "Y" or "N"

So i want to be able to delete the phone number  in the column one which its associated DNC column  if labeled "y" and leave it alone if labeled "N". thanks in advance 

1 Reply

@codyhtch40195 Rather than deleting data, why not clean-up the table a bit and put a filter on the DNC column? See attached file.

Or, if you are a MS365 subscriber, your Excel version perhaps supports the FILTER function.