how do i see which data matches between two worksheets?
in [Functions]
|
From: Judy on 25 Feb 2010 12:16 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.
From: Eduardo on 25 Feb 2010 13:43 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.
|
Pages: 1 Prev: Saving Pivot Tables Next: returning a date 7 business day excluding holidays in the future |