View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rodchar rodchar is offline
external usenet poster
 
Posts: 80
Default comparing 2 sheets

hey all,

i have 2 sheets that contain a column of names on both

s1
john
amy

s2
john
chris

is there a way to find out, for example, names in s1 that don't exist in s2?

thanks,
rodchar