Results 1 to 4 of 4

Extract only those lines which guarantee minimum 2 correct.

Threaded View

  1. 09-30-2023, 07:48 AM #1
    Motilulla
    Motilulla is offline
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    433

    Extract only those lines which guarantee minimum 2 correct.

    Using Excel 2010

    Hello,

    I have here 27 combinations within 3 columns created by 1X2, 3^3=9

    Is there any excel VBA that can extract out of 27 only those rows that guarantee 2 match correct within any of 27 combinations.

    Combinations sheet attached.

    Regards,
    Moti
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lottery euromillones combinations that guarantee 3 or 4 numbers
    By Motilulla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2023, 01:41 PM
  2. Extract city, state, zip, country only from cell with lines with wrapped lines
    By mimibrown in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-12-2023, 04:26 AM
  3. In each worksheet check minimum row height and correct
    By KathCobb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2022, 01:45 PM
  4. Extract minimum time for a specified text string
    By Runner21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2017, 02:02 PM
  5. [SOLVED] Extract 1st and 2nd minimum numbers from a column
    By bobboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2013, 05:25 PM
  6. guarantee virus-free macro?
    By rasmuscm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2010, 10:36 AM
  7. [SOLVED] Oooh, I guarantee you are going to have fun with this one.
    By Clueless in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2006, 02:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1