Sorting a List

C

capnsean

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.
 
G

Guest

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.
 
Top