I'll throw something out all of you weigh in on it and see if it will do what's needed. Select the entire sheet Except the row containing the headers. Next go to Sort. choose Column A (or whatever the header name is in column A. that will put all duplicated items together.
Forums Macs Mac Apps and Mac App Store delete duplicate cells in Excel 2008 Discussion in ' Mac Apps and Mac App Store ' started by angelica22, Jul 19, 2010. With Excel's conditional formatting, you can highlight cells based on specific rules.There are some built-in rules available, and you can use formulas to create your own formatting rules. Highlight Duplicates. In this example, we want highlight duplicate records in a table.
select the rows that have the duplicated names. the Go to Edit Delete and choose to move up. (make sure you leave one you will have to choose desired one to keep.) If it is a Half-backed idea say so. From the way its being explained that would be the way I would do it. If my reply has helped, mark accordingly - Helpful or Answer Phillip M. Jones, C.E.T.
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.