Hi all of u

Case 1:I want to lookup with a multiple criteria in a single spreadsheet and other spreadsheet might be 2 ,3, 4 ,etc.How can I create a user defined function in vba.

Case 2:Secondly,I have a list of data in Column B and want to highlight and extract those list which are duplicates.

Pls let me know.