open office calc tutorial3

This tutorial illustrates a couple of the inbuilt functions within Calc and how to configure them. It looks at Vlookup and Countif Check out the full collection at http://opensourcesource.wikispaces.com

Category:

Education

Tags:

• Vlookup
• Countif
• open source
• open office
• Calc
• tutorial

[dakinane]

Yep use the "Autofill" function. Do the formula for one column, then drag it across the rest.

[riverstrat]

When you put in a Chart there is an anchor that apears, what can you do with that anchor, what use is it ?

Please don't cut an paste the ms explanation.

Thanks.

[cbr0oks]

my daughter can only count to ten . . . but that means she could still count the number of pixels in this video.

[Ken106]

Can anyone figure out how to space columns/rows equally? This things is driving me insane...

[threecheerer]

hey do you know how i can set the the trend lines of my scatterplot graph charts to have a y-intercept of zero? so there would be no y-intercept on the graph's formula? thanks.

[xxdigipiratexx]

Ok. I've been scratching my brain on thsi one a bit. Also found a bug in the OpenOffice countif function that if the comparison contains any punctuation, it will return 0, but enough about that. What I have is a column I have sorted and made unique in a new column. I want to compare items in column b to column a and countif the found results. It works, but I have 7000 items to do this forumal for. Is there a quick way to do this without retyping the formula for each item? Anyone know a way?

[alejandrogg1]

Thanks for the tutorial , is very good, is there a third part?

Alex

[antoneros]

Or see any of the spreadsheet detail?

[antoneros]

Can anyone actually understand this guy?