Somersault Justice!

…and dead end irony…

Cleaning Duplication with Excel 2010

I was merging old annual activity reports provided to the government office into one sheet. It should had been easier if those projects are annual projects too,but they’re not. It was a massive list with amendments, time extension, early termination, project renaming. I have to be careful picking the most updated and delete the obselete.

Normally I would just put auto filter and sort by title. But really, I can’t just rely on my tired eyes because I would miss too many duplications.

How to make excel tell you if there’s a duplication?

Try conditional formatting trick.

1) Prepare your data. (This is not the list I was working btw, it’s a movie list I took from somewhere…)

Image

2) Highlight the cells. Pick : HOME -> CONDITIONAL FORMATTING -> DUPLICATE VALUES

Image

3. Tada!

Image

If you highlight the whole columns, excel will keep alert you if you add another duplication below.

However it should be noted that, it works only for texts with exact spelling. To avoid further duplication, you would still need to apply sort by title / and or other detail as secondary weapon..

Good luck.

Apparently Microsoft also has a page describing this trick step by step,

http://office.microsoft.com/en-001/excel-help/find-duplicate-values-fast-by-applying-conditional-formatting-HA102809491.aspx  

 

Single Post Navigation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: