Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching cells (RE-STATED)
I have three speadsheets. In each spreadsheet:
Col A has about 25,000 cells (len = 73). Col B has about 3,000 cells (len = 44). I need to determine, using the 16 left-most characters in Col A and Col B, which of the cells in Col A "match" the cells in Col B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
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 |