Pink Poogle Toy Forum

The official community of Pink Poogle Toy
Main Site
NeoDex
It is currently Sun Dec 15, 2019 10:51 am

All times are UTC




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Need Help with Formulas in Excel 03
PostPosted: Fri Oct 03, 2008 8:56 pm 
Moderator
Moderator

Posts: 2952
Joined: Tue Apr 04, 2006 8:40 am
Gender: Male
Too lazy to buy '07, so I'm stuck with '03 for a little longer. I am looking for a lot of things right now. I'll update/add to my list after each step (I'm doing it as I go along). First, I am looking to find the number of occurrences of a value in a range of cells (so for example, I'm looking for how often '1' occurs in my range of cells, and then want to subtract it from a constant such as '10'). How would I go about doing this?


Image


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Fri Oct 03, 2008 9:19 pm 
Honorary Member
Honorary Member

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender: Female
i think you're after "countif"


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Fri Oct 03, 2008 9:56 pm 
Moderator
Moderator

Posts: 2952
Joined: Tue Apr 04, 2006 8:40 am
Gender: Male
Nevermind, I found someone who helped me :P Thanks, Rachel

Next question: I would like to know the formula that can be used for situations like this:

I have 30 numbers from 1-30. I have picked 2, 18, and 25. What are the odds that the next number is higher/lower than 25? How would I do that?


Image


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Fri Oct 03, 2008 11:38 pm 
Honorary Member
Honorary Member

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender: Female
you'd need to do something to do with counting how many are left either side of the number then calculate the odds... without knowing exactly what you're trying to do i cant really help anymore than that.

Oh, and i don't think that there are really many differences in terms of the functions you can use between office 2003 and 2007.


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Sat Oct 04, 2008 12:19 pm 
Beyond Godly
Beyond Godly
User avatar

Posts: 2514
Joined: Sun Mar 06, 2005 10:35 am
Location: England
Gender: Male
Our college has updated to 2007, and many people don't like it. I don't mind it, but would say its lost some of the functionality of earlier versions, and is harder to navigate. So yeah, don't feel too bad about having 2003.


Image
Click the wonderful signature. You know you want to.


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Sat Oct 04, 2008 1:35 pm 
Moderator
Moderator

Posts: 2952
Joined: Tue Apr 04, 2006 8:40 am
Gender: Male
Yeah, my school also updated to Office '07 and it's a bit more difficult to navigate and do things in general.


Image


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Tue Oct 07, 2008 7:42 am 
Honorary Member
Honorary Member

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender: Female
It doesn't have less functionality, it definitely has more. It takes a little while to get used to it, and i sometimes wish it was possible to make the navigation bar along the top narrower, but i really like it, i has some great new functions.

For example i'm a big fan of conditional formatting, and there are extra conditional formatting options, and it's much easier to add and modify any conditional formatting you have in a spreadsheet.


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Mon Oct 20, 2008 10:02 pm 
PPT Toddler
PPT Toddler

Posts: 113
Joined: Mon May 31, 2004 9:04 pm
Location: The Kitchen Table
Rachel wrote:
It doesn't have less functionality, it definitely has more. It takes a little while to get used to it, and i sometimes wish it was possible to make the navigation bar along the top narrower, but i really like it, i has some great new functions.

For example i'm a big fan of conditional formatting, and there are extra conditional formatting options, and it's much easier to add and modify any conditional formatting you have in a spreadsheet.


Rachel , you might be able to advise me in that case.

When I use conditional formatting in '07, I only get the option to conditionally format three rules at a time. Is there a way of increasing the number of rules you can format in a single column/row? I regularly have a need to format results for up to half a dozen sets of information in a single column.... :(


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Wed Oct 22, 2008 9:09 am 
Honorary Member
Honorary Member

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender: Female
i'm not at home at the moment so dont have access to office 07, but i can have a look when i get back. if i havent posted again by the end of next week poke me to remind me.


Top
 Profile  
 
 Post subject: Re: Need Help with Formulas in Excel 03
PostPosted: Wed Oct 29, 2008 4:12 pm 
PPT Toddler
PPT Toddler
User avatar

Posts: 118
Joined: Mon Oct 27, 2008 2:34 am
Gender: Male
I much prefer Openoffice.org Calc to MS Excel... It's free, for a start, and a lot less... Noisy. ;)
Quote:
Is there a way of increasing the number of rules you can format in a single column/row?

I'm not sure if this is what you want, but according to a quick google, you can add rules under Conditional Formatting > Manage Rules > New Rule... If that's not what you're looking for, maybe this page from the MSDN can help?


Image
question? check the dex


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group