Finding and filtering on a group of cells

[gundas]

I have a master excel file that has 3 columns with data lets call them A, B, and C. Then I have smaller excel files that have column A only which in both cases "A" is an unique identifier. Is there a way for me to insert the smaller file "A" data into the master excel file column D and be able to find and filter on only those values so that they match the master file column A



Thanks

[OTPM]

Hi
If I understand you correctly you could have a formula in column E (once you have pasted the smaller files into column D) that check for a match between columns A and D and puts a YES in column E, you can then filter on YES in Column E. So the formula would look like this:

=IF(A1=D1,"Yes","No")

Hope this helps.
Tony