Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching cells
How can I determine which cells in Column A contain the same contents
as cells in Column B? (Column has 9,800 cells; Column B has 3,600 cells). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching cells
Assuming column C is available, otherwise use another that is and that range
for stuff in A is A1:A9800, and that range for B starts in row 1 also, in C1 put: =Countif(A$1:A$9800,B1) and fill down to the end of the stuff in B - this will give you a count of the number of times the value in B appears in A. "GARY" wrote: How can I determine which cells in Column A contain the same contents as cells in Column B? (Column has 9,800 cells; Column B has 3,600 cells). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching cells
Thanks, but I want to see the contents of the cells in Col A that match
(or don't match) the contents of the cells in Col B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Matching cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |