# How to delete combinations?

1. ## How to delete combinations?

Hi!

I would like to solve this;

I have three columns with combination numbers

123
345
678
369
and i have special combination 134579

I want to keep row of combinations that doesnt contain all three numbers from special combination, results;

123
678
369

Anyone? And please give me much as possible info, because im a newbe, thanks!  Register To Reply

2. ## Re: How to delete combinations?

try
=SUM(--(NOT(ISERROR(SEARCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),B\$1)))))=3 *array entered
you will get TRUE to delete number
or
=IF(SUM(--(NOT(ISERROR(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),B\$1)))))=3,"",A1) *array entered
you will get required numbers
or
=IF(SUMPRODUCT(--(NOT(ISERROR(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),B\$1)))))=LEN(A1),"",A1) normal entered

*Array entered means use Control+Shift+Enter

btw. formula cannot delete anything

If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)  Register To Reply