Thread: Formula to sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kix kix is offline
external usenet poster
 
Posts: 2
Default Formula to sort

I have two columns 1st column has certain account numbers, the 2nd has those
same numbers plus a couple hundred more. I want to eliminate the account
numbers in 2nd column that do not exist in 1st column. I don't know how to
write a
formula for this.

Thank you.