Results 1 to 7 of 7

Subtracting data from a list?

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    Ottawa, Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Subtracting data from a list?

    Hi all, new member here.

    I'm working with a query tool that generates lists of data and exports to Excel worksheets. A certain query I'm working on right now returns a list of over 2700 line items, and each of these items needs to be examined manually...

    Based on a search criteria, I'm able to use a filter to query a list of over 700 items that are part of the original query, but do not need any attention.

    Question: How can I subtract the ~700 items in the second query from the original query list? Each query exported to Excel generates a new worksheet. No, the query tool does not have the ability to filter out these line items on its own.

    Thanks!

    P.S. I'm not a deeply skilled user, so I need things in layman's terms!

    EDIT: Each query outputs a new workbook, not a worksheet.
    Last edited by Blue Angel; 02-23-2011 at 09:29 AM.

Thread Information

Users Browsing this Thread

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

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