OpenOffice Calc - Tutorial - Removing Duplicate Data (Deduping) by Phillip J Rhoades

http://youtube.com/howtophil
Check out my HowToPhil channel for more tutorials

This is a tutorial for OpenOffice Calc http://openoffice.org showing how to remove duplicate data (deduping)
by Phillip J Rhoades http://ungab.com

Video recorded in gtk-RecordMyDesktop http://recordmydesktop.sourceforge.net

Editing in Blender http://blender.org Synfig http://synfig.org and Avidemux http://fixounet.free.fr/avidemux

Category:

Howto & Style

Tags:

• openoffice
• calc
• ods
• xls
• spreadsheet
• excel
• dedupe
• duplicate
• data
• standard
• filter
• sort
• phillip
• rhoades
• spread
• sheet
• open
• office
• source

[casadapazaosdeabraao]

We can't find many Cal tutorials on web, even more difficult to find some like this one - thank you!

[iamsemjaza]

@casadapazaosdeabraao You're welcome. And Thank you. :) Please check out and subscribe to my HowTophil channel here on youtube where I'll be posting more tutorials. :)

[onlinkteam]

Many thanks!

[iamsemjaza]

@onlinkteam You're very welcome. :) Check out my HowToPhil channel here on youtube for more tutorials etc form me. :)

[zuniedgewater1]

THANK YOU!!!!!!! This will save me lots of time at doing my job.

[iamsemjaza]

@zuniedgewater1 You're welcome. :)

[mistertattooboy]

I really don't know why you put this tutorial together but thank you very very much, You just don't know how much time you saved me.

thanks

[InChristAlive]

Sheeeesh, finally a good video on this, it's still a few too many moves just to remove dupes, times that by doing it 50 times daily and it gets to be a pain. I wish they would create a simple remove dupe button like excel...Thanks for the video

[zegron]

What If I need to do this to multiple columns? I have a huge spreadsheet, 2600 rows and about 20 columns and there are a lot of duplicate rows/columns that are all exactly the same. can I use a some kind of variation of this to hide the duplicate row/columns?

[GrassiRichard]

Very helpful; thank you so much!

[ch880625]

Thank you very much :D

[babybridges]

Thank you so much - that was just what I needed :)

[sc456a]

Great tutorial - thanks for taking the time!

[YellowGreenMedia]

Thank you very much