Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicates
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicates
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 "Dan @BCBS" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicates | Excel Discussion (Misc queries) | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
duplicates | Excel Discussion (Misc queries) | |||
Sum Duplicates | Excel Discussion (Misc queries) |