+ Reply to Thread
Results 1 to 2 of 2

How to delete combinations?

  1. #1
    Registered User
    Join Date
    07-09-2017
    Location
    London, England
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    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!
    Last edited by Punkobrod; 07-09-2017 at 04:18 AM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    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)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.
    Last edited by sandy666; 07-09-2017 at 07:12 AM. Reason: file added
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete duplicates value combinations from two columns
    By Julia2937 in forum Excel General
    Replies: 2
    Last Post: 03-29-2013, 07:03 PM
  2. Replies: 7
    Last Post: 01-14-2013, 11:08 AM
  3. any six from ten combinations
    By barney1943 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 01:49 PM
  4. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM
  5. Replies: 4
    Last Post: 03-09-2011, 12:16 PM
  6. All Possible Combinations
    By tlhood1080 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2009, 11:44 PM
  7. Combinations
    By mcatapano in forum Excel General
    Replies: 2
    Last Post: 02-16-2009, 12:46 AM
  8. [SOLVED] Combinations
    By osprey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1