View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARY
 
Posts: n/a
Default 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.