+ Reply to Thread
Results 1 to 13 of 13

Formula (array?) to list unique entries that match criteria?

Hybrid View

  1. 11-11-2014, 03:19 PM #1
    Rerock
    Rerock is offline
    Forum Contributor
    Join Date
    07-22-2009
    Location
    Minneapolis, MN
    MS-Off Ver
    2016
    Posts
    220

    Re: Formula (array?) to list unique entries that match criteria?

    Quote Originally Posted by AlKey View Post
    Array entered

    =IFERROR(INDEX(A$2:A$11,MATCH(0,IF(B$2:B$11>0,"",COUNTIF(E$1:$E1,A$2:A$11)),)),"")
    That seems to list all of the items in column "A", that have a negative value in column "B"...

    Can we have it match cell $D$2 with column "C", AND has a negative value in column "B"?
    Last edited by Rerock; 11-11-2014 at 03:21 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Looking to create a list of unique names that match criteria without using an array
    By john dalton in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-28-2014, 04:28 AM
  2. [SOLVED] Create a list of unique entries that did not meet a specific criteria
    By joannelittell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2013, 12:08 PM
  3. Create list of unique entries from workbook 1 that also match criteria to new workbook
    By Nog574544 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2013, 07:16 AM
  4. Unique list Array Formula dependent of two criteria
    By ron2k_1 in forum Excel General
    Replies: 3
    Last Post: 09-01-2011, 10:50 PM
  5. Non-array formula listing of unique entries in a DB field
    By quatrecouleurs in forum Tips and Tutorials
    Replies: 0
    Last Post: 05-11-2010, 09:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1