I'll just do this empirically:

I column A contains:
W
X
Y
Z
A
B
C

and column B contains:
R
Z
S
T
A

Is there a way I can write something to look see where column A and B
overlap. To make this a little more difficult - we're not just looking
at something alphabetic, and I'm looking in a list of 10,000 variables
for 1000 potential matches. So even if I could get those that match to
become bold, for example, that would be fine.


Sorry about the motley message - difficult to explain.


--
capnsean
------------------------------------------------------------------------
capnsean's Profile: http://www.excelforum.com/member.php...o&userid=25049
View this thread: http://www.excelforum.com/showthread...hreadid=547853