Results 1 to 18 of 18

Pull Results with double Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,617

    Pull Results with double Criteria

    Column E to I is the dictionary
    Column K to O are results based on what is fed on c1 and c2

    When vowels are asked for 3 it should pull words with even 4 vowels , 3 is the minimum
    When column c2 is left BLANK it should search against criteria c1 which is letters regardless vowels condition
    I have pasted dictionary for 2oo words , it does not have letters with 2 vowels
    Column c1 should not necessarily be three letters , It should allows E.G DL which is a two letter word

    File attached

    Those expected results i copy pasted , maybe there are more than that
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula double counting results?
    By joshdog13 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-30-2021, 06:46 PM
  2. Formula to Pull Multiple Results from Column Matching Same Criteria
    By rfowl0106 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2019, 07:40 PM
  3. [SOLVED] Double Results in the same cell
    By jatolo in forum Excel General
    Replies: 15
    Last Post: 04-27-2018, 07:52 PM
  4. Compare data on two sheets and pull multiple results based on criteria
    By Mandross in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-20-2017, 06:58 PM
  5. Macro to pull data from workbooks and return double sided accounting entry
    By JediAccountant in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 08-27-2013, 11:16 AM
  6. [SOLVED] Why macro needs double click to get the actual results ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2013, 05:04 AM
  7. Double clicking the results in Listview to bring up another userform
    By vbanew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-22-2011, 04:29 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