Results 1 to 6 of 6

Unique list with criteria, criteriarange multiple columns.

Threaded View

  1. #1
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,333

    Unique list with criteria, criteriarange multiple columns.

    I have an array formula in F4:F13 that generates a unique list from B17:B25 with criteria in B4 and criteriarange in D17:D25.
    How to expand formula to include F17:F25 and H17:H25 in criteriarange ?
    In the example file 876678 should also appear in the list.

    TIA

    Rudi
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unique list with AND and OR logic as multiple criteria
    By T86157 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2017, 09:21 PM
  2. Unique list from multiple responses to multiple criteria
    By 0Stump3 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-12-2015, 12:11 PM
  3. Create Unique List from Multiple Criteria
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2015, 04:20 PM
  4. [SOLVED] Create list returning unique criteria covering several columns using arrays
    By joannelittell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2013, 04:37 PM
  5. [SOLVED] Create list returning unique criteria covering several columns
    By joannelittell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2013, 04:27 PM
  6. Count unique values across 2 columns with multiple criteria
    By Skywalker01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2012, 08:04 AM
  7. [SOLVED] Using SUMIFS with Defined Name as CriteriaRange and a name as Criteria
    By nerrett in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2012, 08:07 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