I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.
Check for Duplicates in an Excel List
To check an Exel list for duplicate entries, first select the list and name it using Insert, Name, Define and call it ListToCheck.
Now, select the list (and, assuming the list starts in cell A2), choose Format, Conditional formatting and type Formula Is and then
=Countif(ListToCheck,A2)>1
Then click Format to apply a format and click Ok.
Now each cell containing a duplicate entry will be formatted so you’ll see it clearly.
Labels: Uncategorized
Labels:office
Post a Comment
Please feel free to add your comment here. Thank you!