it is showing the matches. But two things are not happening. First instead of deleting the unmatched rows, the unmatched cell of Column A are showing #NA. Second the rest of column upto G are coming blank. And what is the meaning of paste it out to column G. Does this mean the same formula to enter in all the columns upto G.
I can't think of any way to autopopulate Sheet3 without first adding helper columns to Sheet1 to determine if Sheet1 values match Sheet2.
Hopefully someone else can be of further assistance.
edit: You could put a filter on Sheet3 and just filter out the #VALUE!
Last edited by daffodil11; 07-26-2013 at 01:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks