As per forum rules, post your questions in the appropriate main forum for the benefit of all. Include a sample workbook with sample before/after examples to make helping you simple. Thanks. Feel free to message me a link to your your thread to draw my attention.
Hi JBeaucaire, Hope you can help me. Need to find if duplicate values exist in a column A and B, then copy - paste ROW to new sheet. DATA Sheet1 Column A Column B Column C Surname Firstname Addresss Conde Zaldy USA Conde Janice CHI Gates Billy PHIL Conde Zaldy CHI Results : DATA Sheet 2 Column A Column B Column C Surname Firstname Addresss Conde Zaldy USA Conde Zaldy CHI Thanks in advance, Zaldy