Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Subtracting results

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Say I have 20 new cusomers without catalogs and 15 customers with catalogs. Is there a way I can tell excel to subtract the without group from the with and show me which do not have catalogs? In other words only show the list the hasnt received catalogs. Also, would this be easier to send the excel data to access and have access do this?
    Thanks

  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 07:50, kerrysr wrote:
    Say I have 20 new cusomers without catalogs and 15 customers with catalogs. Is there a way I can tell excel to subtract the without group from the with and show me which do not have catalogs? In other words only show the list the hasnt received catalogs. Also, would this be easier to send the excel data to access and have access do this?
    Thanks
    kerrysr,
    I assume that your data is like this:
    In column A - customers name.
    In column B - indicator for having catalog e.g. Y/N or 0/1.
    You can now use AutoFilter on column B to show only rows of customers which hasn't received catalogs.
    from toolbar click: Data | Filter | AutoFilter - and choose ctegory for column B.
    Eli

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •