Sorting a List
 

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

Sorting a List
 

Hi

You could use Conditional Formatting. If your columns are A and B, select
column A and go to Format/Conditional Format. Select 'Formula is' and in the
dialog box type:
=COUNTIF($B:$B,A1)0
You can also do a similar thing with column B.

Hope this helps.
Andy.

"capnsean" wrote in
message ...

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