Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 3 of 3
  1. 01-28-2009 04:57 AM #1
    dTHMTLGOD Guest

    Default Counts more than one

    I would like to determine if I have more than one occurrence of two criteria

    User CN
    AA42171 Computer1
    AA42171 Laptop1
    AB44593 Computer1
    AF45945 Computer1
    DF86535 Computer1
    DF86535 Computer2

    I would like to pull if a user has both a Computer1 and Laptop1



    Reply With Quote Reply With Quote  
  2. 01-28-2009 04:57 AM #2
    Bob Phillips Guest

    Default Re: Counts more than one

    Use conditional formatting on the first column with a formula of

    =COUNTIF(A:A,A1)>1

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "dTHMTLGOD" <DTHMTL@YAHOO2.COM> wrote in message
    news:eN0M1KGaGHA.4752@TK2MSFTNGP02.phx.gbl...
    > I would like to determine if I have more than one occurrence of two
    criteria
    >
    > User CN
    > AA42171 Computer1
    > AA42171 Laptop1
    > AB44593 Computer1
    > AF45945 Computer1
    > DF86535 Computer1
    > DF86535 Computer2
    >
    > I would like to pull if a user has both a Computer1 and Laptop1
    >
    >
    >


    Reply With Quote Reply With Quote  
  3. 01-28-2009 04:57 AM #3
    Stefi Guest

    Default RE: Counts more than one

    Maybe this can be a solution for you:
    Enter in C2
    =IF(ISERROR(MATCH(A2,A3:A7,0)),"",INDEX(B3:B7,MATC H(A2,A3:A7,0)))
    and fill down as required.

    > User CN Additional machine
    > AA42171 Computer1 formula
    > AA42171 Laptop1 |
    > AB44593 Computer1 V
    > AF45945 Computer1
    > DF86535 Computer1
    > DF86535 Computer2

    Regards,
    Stefi

    Reply With Quote Reply With Quote  
« Previous Thread | Next 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

Forum Rules