Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lock columns together in a single row for sorting purpos. | Excel Discussion (Misc queries) | |||
Regarding Sorting Columns | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
Sorting or aligning columns | Excel Discussion (Misc queries) | |||
Automatic Sorting of a group of columns. | Excel Worksheet Functions |