sorting two columns together

B

bullseye

How do I sort two columns simultaneously to identify duplication between
the two? Say one column (A) has 20 cells, the next column (B) has 75.
Currently, I enter each value from A under "find" and check for
duplication in column B. Is there a command to find duplications
between the two?
 
B

bj

one of the ways to do this is to use conditional formating
select one of the columns (column A?) (column B second data set?)
<Format><Conditional Formating>
formula is =countif(B:B,A1)>0
set the format as you want it
(You may have to go back into conditional formating to insure unwanted Quote
marks and relative versus absolute cell references are correct)
 
Top