| 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 rows; Column B contains 3,600 rows). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching cells
Please try this ...
- Paste it in C1 =VLOOKUP(A1,$B$1:$B$3600,1,0) - Copy and paste C1 to C2 to C3600 if you get "#N/A", that is not available in Column B, or else you will get same as Column A. Please rate me. "GARY" wrote: How can I determine which cells in Column A contain the same contents as cells in Column B? (Column has 9,800 rows; Column B contains 3,600 rows). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching cells
Don't I need to copy and paste the formula from C1 to C9800?
|
| 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 | |||
Linear Mode
