# Excel 2000 Filtering columns of data

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

Not open for further replies.

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. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,749
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")

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. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,749
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,

File size:
14.5 KB
Views:
90
5. ### etafModerator

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

#### Attached Files:

• ###### phone numbers.xls
File size:
18.5 KB
Views:
91

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

7. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,749
First Name:
Wayne
let us know if it works all OK

As Seen On