# Pink Poogle Toy Forum

The official community of Pink Poogle Toy
Main Site
NeoDex
 It is currently Mon Aug 10, 2020 8:05 am

 All times are UTC

 Page 1 of 1 [ 10 posts ]
Author Message
 Post subject: Need Help with Formulas in Excel 03Posted: Fri Oct 03, 2008 8:56 pm
 Moderator

Posts: 2952
Joined: Tue Apr 04, 2006 8:40 am
Gender:
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?

Top

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

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

Top

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

Posts: 2952
Joined: Tue Apr 04, 2006 8:40 am
Gender:
Nevermind, I found someone who helped me 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?

Top

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

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender:
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

 Post subject: Re: Need Help with Formulas in Excel 03Posted: Sat Oct 04, 2008 12:19 pm
 Beyond Godly

Posts: 2514
Joined: Sun Mar 06, 2005 10:35 am
Location: England
Gender:
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.

Top

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

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

Top

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

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender:
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

 Post subject: Re: Need Help with Formulas in Excel 03Posted: Mon Oct 20, 2008 10:02 pm
 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

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

Posts: 4363
Joined: Tue Jul 13, 2004 2:40 am
Location: Down Under
Gender:
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

 Post subject: Re: Need Help with Formulas in Excel 03Posted: Wed Oct 29, 2008 4:12 pm
 PPT Toddler

Posts: 118
Joined: Mon Oct 27, 2008 2:34 am
Gender:
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?

Top

 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending
 Page 1 of 1 [ 10 posts ]

 All times are UTC

#### Who is online

Users browsing this forum: No registered users and 2 guests

 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum

Search for:
 Jump to:  Select a forum ------------------          Webkinz          Arcade          Club Penguin Chat Pink Poogle Toy    Forum Discussion       Bug Reports    Everything You Need To Know About The Pink Poogle Toy Forum    Newbie Welcome Wagon Online Games    Neopets Chat       Neopian Plot Council       Neopets Advertisements    Moglings    Subeta Chat Miscellaneous    Miscellaneous Discussion    Coconut Isle    Jokes    Computing & Technology    Promotions & Plugging Entertainment    Movies & Television    Anime & Manga    Music Discussion    Gaming    The Locker Room    The Library Creative    Ye Olde PPT Gallery    Tutorials and Advice    Signatures and Avatars Requests    Roleplaying Boards