Results 1 to 3 of 3

Pull Values from List Exluding Matching Values in Second List

Threaded View

sskgintl Pull Values from List... 07-15-2014, 09:45 PM
azumi Re: Pull Values from List... 07-15-2014, 09:52 PM
sskgintl Re: Pull Values from List... 07-16-2014, 09:29 PM
  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2010
    Posts
    43

    Pull Values from List Exluding Matching Values in Second List

    The basic question is: Is it possible to pull a list of values out of an array based on a couple of criteria, but exclude them if they exist with certain criteria in a second array?

    To be more concrete: I have a spreadsheet tracking a fundraising campaign. Tab 1 is "All Donations" and lists every donation received. Tab 2 is "Pledges" and lists donations that have been promised, but not yet made. I am creating a third tab to pull a summary of the month's activity a committee.

    I can successfully pull a list of all of the donations from the past month using this formula:

    =INDEX('All Donations'!D:D,SMALL(IF('All Donations'!$C:$C>=(EOMONTH($B$3,-1)+1),IF('All Donations'!$C:$C<=$B$3,ROW('All Donations'!$A:$A))),ROWS($A$31:A31)))

    I would like to exclude any donations which show on the Pledges tab as having been applied toward a pledge. This means checking 3 criteria on the Pledges tab - the name (column A), the date (J) and amount (K). If all 3 of these match the data on the All Donations tab, the record should not show on the list.

    My best shot at it was adding the red if functions:

    =INDEX('All Donations'!D:D,SMALL(IF('All Donations'!$C:$C>=(EOMONTH($B$3,-1)+1),IF('All Donations'!$C:$C<=$B$3,IF('All Donations'!$C:$C<>Pledges!J:J,IF('All Donations'!D:D<>Pledges!A:A,IF('All Donations'!E:E<>Pledges!K:K,ROW('All Donations'!$A:$A)))))),ROWS($A$33:A33)))

    Needless to say, it didn't work. So, I'm appealing to anyone brilliant (or at least smarter than me) out there.
    Last edited by sskgintl; 07-15-2014 at 09:46 PM. Reason: typo

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to pull values from a column, and list them in a cell
    By Naja in forum Excel General
    Replies: 11
    Last Post: 11-05-2012, 04:38 PM
  2. Copy/Paste Cells from old list to new master list by matching values
    By rfsmith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2012, 05:32 PM
  3. Need to pull non-zero values from one sheet to another in a list
    By povictory in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2012, 01:15 PM
  4. List matching values
    By WebKill in forum Excel General
    Replies: 6
    Last Post: 03-30-2011, 03:32 PM
  5. Matching a value to a list of values
    By s.w in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2007, 10:43 AM

Tags for this Thread

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