Forum Discussion

Victoria Mathys's avatar
Victoria Mathys
Copper Contributor
Nov 14, 2017

Need help with formula

I am in need of some help deciding which is the correct formula to us as well as how to create iti am looking to highlight duplicate rows of information. 

Row1 is all titles:  name (a1), address (b2), phone (C3), some of the 70 sheets I have 300 rows.   

I have copied and pasted information from  4 workbooks  to create a master workbook, and would like to review what details are duplicated.  Then manually delete the row.

 

which formula do i use?  and how do i get duplicates highlighted?

 

I am working on 2016 Excel 365 home edition.  So there is no compare command.   

 

 

Resources