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

[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 :)

[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. :)

[sc456a]

Great tutorial - thanks for taking the time!

[YellowGreenMedia]

Thank you very much

[iamsemjaza]

@havoc40000 You're very welcome. Be sure to check otu my HowToPhil channel here on youtube for more How-To videos by me. :)

[accbandung]

Thank you! The easiest method online and it's a video!

[meethed]

THANKS A TON!!!! Great, simple tutorial that worked like a charm.

[eddiedefro]

This is very helpful. I'm starting to use filters in oO Calc a little. i have a question, how can a see all my data again after I've used a filter? the "Remove Filter" is grayed out

[eddiedefro]

@eddiedefro Never mind, I found it: Right on row number and "Show". Thanks again for the great vid!

[onlinkteam]

Many thanks!

[iamsemjaza]

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

[WebDialogueEU]

Great, thanks!

[stevelco]

Thank you so much!!! I've been looking for the answer to this question for weeks, and nobody seems to have this simple solution to the problem. Beautiful! :-)

[zuniedgewater1]

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

[iamsemjaza]

@zuniedgewater1 You're welcome. :)

[billjoyce69]

Hey what a time saver!! so simple I was trying to reinvent rge weel or look for "macros" Jesus wat a relief.

Great job no muss no fuss Keep up the good wrk

Bill in Atlanta

[MrKimB]

Hello Phillip,

Thanks so much for posting this. I'm making the transition from Excel 2000 and could not find how to do this in Calc.

Thanks again,

Kim

[iamsemjaza]

Glad to help. :)

[TheAznKidszs]

i need some help on openoffice calc :( can u tell me how to make a scatter plot? and how to make a pie chart when i only wanna use the A colum which is a gender data w/ 50 datas on it

[GJL2K]

Very helpful. I just used this in conjunction with an applescript to find all the paragraph styles in an InDesign document, then filtered out the duplicates and created a spreadsheet, following your video. You rock.

[markandsonja]

Excellent thank you

[iamsemjaza]

You're very welcome. :)