1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2000 Filtering columns of data

Discussion in 'Business Applications' started by wheaty, Feb 4, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. wheaty

    wheaty Thread Starter

    Joined:
    Feb 4, 2009
    Messages:
    3
    Helloooo
    I have two columns of data. In column A, I need to identify every cell that is identical to any value in column B.
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,676
    First Name:
    Wayne
    This should work
    =COUNTIF($A:$A,$A1)=1
    OR
    Also if you sort the column A
    and then use
    =IF(OR(A2=A1,A2=A3),"dup","unique")
     
  3. wheaty

    wheaty Thread Starter

    Joined:
    Feb 4, 2009
    Messages:
    3
    Thanks a lot for your help.

    Let me explain my problem a little better
    In Col A I have a list of all phone numbers called in the month (those to my wife, my bookie, my client, my girlfriend (don't tell my wife..), etc.)
    In Col B I have the number of minutes of each of the above phone calls.
    In Col C I have a list of phone numbers (reimbursable) made on behalf of the client.
    I need to somehow identify each cell in Col A when it matches any of the phone numbers in Col C.
    With these identified, then I need to document the purpose of the phone call and total the number of minutes so that proper reimbursement can be made.
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,676
    First Name:
    Wayne
    use vlookup
    I would put this into a seperate worksheet
    so in column D
    =VLOOKUP(A2,C$2:C$6,1,FALSE)

    see attached file

    No you could have a reason in another column and pick that up with the lookup

    I wont be able to show that till tomorrow now,
     

    Attached Files:

  5. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,676
    First Name:
    Wayne
    heres the example using a seperate sheet and a reason
     

    Attached Files:

  6. wheaty

    wheaty Thread Starter

    Joined:
    Feb 4, 2009
    Messages:
    3
    You are the greatest thanks so much!
     
  7. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,676
    First Name:
    Wayne
    let us know if it works all OK
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/797387

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice