Software

Ask something
Discussion Locked

Duplicate Cells

0 helpful
1 reply

by homekey1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a formula to flag or locate duplicate cells? I have a very large mail merge to do and there are some names that are listed more than once.

1 reply

by dklippert

This from Chip Pearsons site - www.CPearson.com

"Highlighting Duplicate Entries

Our first task is to highlight the cells in Range1 that are duplicates. We use Excel's Conditional Formatting tool to accomplish this. First, highlight the entire Range1. Then, select the
Conditional Formatting tool from the Format menu: Format->Conditional Formatting.
Change the "Cell Value Is" option to "Formula Is" and enter the following formula in the
formula text box:

=IF(COUNTIF(Range1, A5)>1,TRUE,FALSE)

Where A5 is the first cell in Range1. Then, click the Format button and select the font or
color you want your cell formatted with. Finally, click OK. Duplicate entries in Range1 will be formatted as you selected. For example, if "Able" occurs twice in Range1, both
occurrences of "Able" will appear highlighted.

This discussion is closed to new replies.