duplicates

[Guest]

I hope this is a simple question!

I have one spreadsheet with two columns, each column is a list of provider
numbers.
All I want to do is identify the provider numbers that are in both columns.

Sounds simple, I've tried many things with no success.

Thanks

 

[JulieD]

Hi Dan

from Chip Pearson's page on duplicates
(http://www.cpearson.com/excel/duplicat.htm)
-----
Extracting Values Common To Two Lists

You can easily extract values that appear in both of two lists. Suppose your
lists are in A1:A10 and B1:B10. Enter the following array formula in the
first cell of the range which is to contain the common entries:

=IF(COUNTIF($A$1:$A$10,B1)>0,B1,"")

Change B1 and $A$1:$A$10 to the first cells in the ranges from which data
that you want to extract common items. Then, use Fill Down (from the Edit
menu) to fill the formula down to as many rows as you need to hold the
common entries (i.e., up to as many rows as there are in the original
range.)

---

NOTE: an array formula (as above) needs to be committed with control &
shift & enter not just enter.

Cheers

JulieD