Somersault Justice!

…and dead end irony…

Archive for the category “Uncategorized”

Syalalala

Test test

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  

 

Yasser Lopez

Kinda gruesome, tapi  Yasser Lopez bisa bertahan hidup setelah anak panah tombak berburu menembus otaknya.
Ini membuat saya berpikir, bagaimana cara kerja otak sebenarnya.

Bagaimana otak menyimpan memori, apakah di tiap sel dengan analogi drive sector?
Apakah ada memori yang hilang?
Apakah ada fungsi bawah sadar yang terganggu?

Rupanya dia beruntung tombak (panah) tersebut tidak mengenai pembuluh utama… Apakah boot sector otak berada di situ?

Post Navigation