Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How can I compare a column from worksheet 1 to a column in worksheet 2 of the
same work book? |
#2
![]() |
|||
|
|||
![]()
BTW, the cell my have a number or text in it but not formulas
"Dan" wrote: How can I compare a column from worksheet 1 to a column in worksheet 2 of the same work book? |
#3
![]() |
|||
|
|||
![]()
What are you looking for?
If you want to find out if each cell in Column A of sheet1 appears in column A of sheet2, you could use a helper column of formulas: =isnumber(match(a1,sheet2!a:a,0)) and drag down And you could use the same kind of formula that will tell you if values in sheet2 appear in sheet1. Chip Pearson has lots of info about working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Dan wrote: How can I compare a column from worksheet 1 to a column in worksheet 2 of the same work book? -- Dave Peterson |
#4
![]() |
|||
|
|||
![]()
Does that do a random search of the other column for the number, or do you
have to just compare cell to cell? "Dave Peterson" wrote: What are you looking for? If you want to find out if each cell in Column A of sheet1 appears in column A of sheet2, you could use a helper column of formulas: =isnumber(match(a1,sheet2!a:a,0)) and drag down And you could use the same kind of formula that will tell you if values in sheet2 appear in sheet1. Chip Pearson has lots of info about working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Dan wrote: How can I compare a column from worksheet 1 to a column in worksheet 2 of the same work book? -- Dave Peterson |
#5
![]() |
|||
|
|||
![]()
It looks for the value in A1 anywhere in sheet2, column A.
It's a sequential search through column A, but once a match is found, it stops looking. But all that stuff is taken care of by excel. You don't have to compare A1 with sheet2!a1, then A1 with sheet2!a2, then with sheet2!a3, .... (I'm not quite sure if this answered your question, though.) Dan wrote: Does that do a random search of the other column for the number, or do you have to just compare cell to cell? "Dave Peterson" wrote: What are you looking for? If you want to find out if each cell in Column A of sheet1 appears in column A of sheet2, you could use a helper column of formulas: =isnumber(match(a1,sheet2!a:a,0)) and drag down And you could use the same kind of formula that will tell you if values in sheet2 appear in sheet1. Chip Pearson has lots of info about working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Dan wrote: How can I compare a column from worksheet 1 to a column in worksheet 2 of the same work book? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Identical Data set in a work sheet | Excel Worksheet Functions | |||
Excel 2002 "Protect Sheet", but allow "Hide Columns"? | Excel Worksheet Functions | |||
Get Msg "Cannot shift objects off sheet" when hidng columns" Why? | Excel Discussion (Misc queries) | |||
Link between similar sheet | Excel Discussion (Misc queries) | |||
Comparing Data in two columns | Excel Worksheet Functions |