sorting two columns together
 

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?

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)


"bullseye" wrote:


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?