Thread: Comparing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Striker3070 Striker3070 is offline
external usenet poster
 
Posts: 16
Default Comparing

I have two columns of numbers column A could be up to 3500 rows. Column B
may be more or less than 3500 rows. What I'm trying to do is see if any
number in columns "B" appears anywhere in Column "A", and if so we can just
highlight it in both columns. Actually I would want to be able to sort by
highlighted. so maybe add someway to sort by matched or unmatched.


I hope this makes sense.