Forum Discussion
Victoria Mathys
Nov 14, 2017Copper Contributor
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.
Hi Victoria,
You may try conditional formatting
- Victoria MathysCopper Contributor
Thanks I will try that.