on 1/30/2011, gcotterl supposed :
I've simplified my spreadsheet. It now has only two columns (A1 thru
A4841 and B1 thru B18513).
My question is: How do I eliminate the cells in Col B whose 19 left-
most characters do NOT match the 19 left-most characters in the cells
in Col A?
Finally! We arive at what it is that you want (remove records).
Hooray!<g
So then, is what you're saying is you want to end up with a list of
only matches where all non-matching records are remove from both
sections? (resulting with both sections having the same number of rows)
OR
Do you want to remove non-matches from Section1 (A1:A18513) only and
somehow align the matches with Section2?
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc