nglreturns.myfreeforum.org Forum Index nglreturns.myfreeforum.org
Nglreturns is a forum to discuss religion, philosophy, ethics etc...

NGLReturns Daily Quiz - Play here!
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   Join! (free) Join! (free)
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


Useful things
Page 1, 2  Next
 
Post new topic   Reply to topic    nglreturns.myfreeforum.org Forum Index -> Tips and hints
View previous topic :: View next topic  
Author Message
Lexilogio
Well Known Chatterbox...


Joined: 25 Aug 2008
Posts: 7585


Location: North of the Watford Gap

PostPosted: Sun Mar 14, 2010 11:01 pm    Post subject: Useful things  Reply with quote

Okay - by request.....


To hyperlink a word:

Open square bracket [
url= then the web address
Close square bracket ]

then type the word you want, followed by
[/url]
_________________
Lexi
Back to top
View user's profile Send private message
Lexilogio
Well Known Chatterbox...


Joined: 25 Aug 2008
Posts: 7585


Location: North of the Watford Gap

PostPosted: Sun Mar 14, 2010 11:03 pm    Post subject: Reply with quote

Want to scroll text?
_________________
Lexi
Back to top
View user's profile Send private message
Dave B
Senior Community Member


Joined: 01 Dec 2009
Posts: 1142


Location: Gloucester

PostPosted: Mon Mar 15, 2010 2:32 pm    Post subject: Reply with quote

Well done Lexi.


_________________
Reality is that which, when you stop believing in it, doesn't go away. - Phillip K. Dick
Back to top
View user's profile Send private message Visit poster's website
Ketty
Moderator


Joined: 26 Aug 2008
Posts: 7376


Location: Walking the narrow path, singing merrily and living Victoriously

PostPosted: Tue Mar 16, 2010 9:16 am    Post subject: Reply with quote



Now, can you give me an idiot's guide to the 'count' function in Excel, please?


_________________
<><Although Christians and Mormons use the same words such as grace, faith, God and sin, they mean very different things by them. Beware the poison!><>
Back to top
View user's profile Send private message
Lexilogio
Well Known Chatterbox...


Joined: 25 Aug 2008
Posts: 7585


Location: North of the Watford Gap

PostPosted: Tue Mar 16, 2010 8:05 pm    Post subject: Reply with quote

Ketty wrote:


Now, can you give me an idiot's guide to the 'count' function in Excel, please?



Which count function do you want?

A straight count?

=SUM(cell:cell)

or count text?

=COUNTIF(cell:cell,"insert text")
_________________
Lexi
Back to top
View user's profile Send private message
Dave B
Senior Community Member


Joined: 01 Dec 2009
Posts: 1142


Location: Gloucester

PostPosted: Tue Mar 16, 2010 10:17 pm    Post subject: Reply with quote

Lexilogio wrote:
Ketty wrote:


Now, can you give me an idiot's guide to the 'count' function in Excel, please?



Which count function do you want?

A straight count?

=SUM(cell:cell)

or count text?

=COUNTIF(cell:cell,"insert text")

Does the "COUNTIF" function count the number of cells that contain either a specific text or value?

I seem to remember one for counting cells that contain a specified number. Unfortunately my old Excell won't load into Windows 7 so I can't check that one. But I have the memory of using it when scanning plots with thousands of logged values and needing to know how many hit the max.

I will have to see if there is anything like it in Open Office.
_________________
Reality is that which, when you stop believing in it, doesn't go away. - Phillip K. Dick
Back to top
View user's profile Send private message Visit poster's website
Dave B
Senior Community Member


Joined: 01 Dec 2009
Posts: 1142


Location: Gloucester

PostPosted: Tue Mar 16, 2010 10:28 pm    Post subject: Reply with quote

Yup, that must have been the one, and it works in Open Office as well. Not that I will be canning mega dumps of logged data whilst I am retired . . .
_________________
Reality is that which, when you stop believing in it, doesn't go away. - Phillip K. Dick
Back to top
View user's profile Send private message Visit poster's website
Lexilogio
Well Known Chatterbox...


Joined: 25 Aug 2008
Posts: 7585


Location: North of the Watford Gap

PostPosted: Wed Mar 17, 2010 9:13 pm    Post subject: Reply with quote

Yes - COUNTIF will count all cells in a specific range with certain text. It will not, though, pick text from a phrase. So searching for a single letter won't pick all those with that letter in a word, but only those cells which only contain that letter.
_________________
Lexi
Back to top
View user's profile Send private message
Ketty
Moderator


Joined: 26 Aug 2008
Posts: 7376


Location: Walking the narrow path, singing merrily and living Victoriously

PostPosted: Fri Mar 19, 2010 7:05 pm    Post subject: Reply with quote

COUNTIF, that's the one!







Another - I've got a spreadsheet containing several sheets.  The value from the formula in a cell in, say Sheet A, I need to copy to Sheet B - that's fine I can do that BUT the value of the cell in sheet A is a negative and when it appears in Sheet B I need it to turn to a positive - how do I get it to turn from a negative from Sheet A to a positive in Sheet B?
_________________
<><Although Christians and Mormons use the same words such as grace, faith, God and sin, they mean very different things by them. Beware the poison!><>
Back to top
View user's profile Send private message
Lexilogio
Well Known Chatterbox...


Joined: 25 Aug 2008
Posts: 7585


Location: North of the Watford Gap

PostPosted: Fri Mar 19, 2010 8:18 pm    Post subject: Reply with quote

Ketty wrote:
COUNTIF, that's the one!







Another - I've got a spreadsheet containing several sheets.  The value from the formula in a cell in, say Sheet A, I need to copy to Sheet B - that's fine I can do that BUT the value of the cell in sheet A is a negative and when it appears in Sheet B I need it to turn to a positive - how do I get it to turn from a negative from Sheet A to a positive in Sheet B?


You need to format the cell - either by right clicking, or by going to Format at the top - then select cell.
You want the first tab - Number, then in the dialogue box go down to number. That gives you the option to turn the number in the cell to always positive (or vice versa).


I like Exel  


_________________
Lexi
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nglreturns.myfreeforum.org Forum Index -> Tips and hints All times are GMT + 1 Hour
Page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Card File  Gallery  Forum Archive
Powered by phpBB © 2001, 2005 phpBB Group
Create your own free forum | Buy a domain to use with your forum