Thread: how do i see which data matches between two worksheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default how do i see which data matches between two worksheets?
Hi,
look CPearson web

http://www.cpearson.com/excel/ListFunctions.aspx

second title Extracting Elements Common To Two Lists



"Judy" wrote:

I need to compare a very long worksheet (W1) to a shorter worksheet (W2) to
see if any of the files listed on W1 are on W2. I then need to copy the
matching rows from W2 to a new worksheet.
Reply With QuoteReply With Quote