Referencing
 

Hi There.
I have 2 columns of client accounts. I need to take the 1st column and
see if any of the account #'s show up in the 2nd column. In a 3rd
Column I want a list that shows which company codes are in both the 1st
and 2nd column. Should I use access for this or can it be done in excel?
Any help would be appreciated..I have to get it done by next thursday!
Thanks! :)


--
Delaina
------------------------------------------------------------------------
Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=381709

http://www.cpearson.com/excel/duplicat.htm

has some nice techniques on how to tag or treat duplicates

Regards

Peo Sjoblom

"Delaina" wrote:


Hi There.
I have 2 columns of client accounts. I need to take the 1st column and
see if any of the account #'s show up in the 2nd column. In a 3rd
Column I want a list that shows which company codes are in both the 1st
and 2nd column. Should I use access for this or can it be done in excel?
Any help would be appreciated..I have to get it done by next thursday!
Thanks! :)


--
Delaina
------------------------------------------------------------------------
Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=381709

Thank you for the reply. I am not able to get his code to work because I
would like column B to look through column A to see if there are
duplicates, not search for duplicates in one column. Is there anywhere
to find that out?
Thanks.

**here's basically what I want it to do**

If(anything in column B=anything in column A, "duplicate", "") I just
don't know how to get column B to do that...


--
Delaina
------------------------------------------------------------------------
Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=381709

Adapted this from the information on cpearson's website above:

C1=COUNTIF($A$1:$A$10,$B1) then copy down to C10 (adjust range
references and such to your specific situation, of course)

This will count the number of times the value in B1 occurs in A1:A10.
If B1 isn't in A1:A10, it returns 0. You can enclose this formula in
an IF function if you want.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=381709

Thank you so much-I wasn't understanding the formula the way the website
explained it. Job well done!


--
Delaina
------------------------------------------------------------------------
Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=381709