|
Printer-friendly format Email this thread to a friend Bookmark this thread |
This topic is archived. |
Home » Discuss » The DU Lounge |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:10 PM Original message |
Anyone good with Excel formulas? I'm stuck! |
Printer Friendly | Permalink | | Top |
Blue-Jay (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:13 PM Response to Original message |
1. RE: Your C Column - |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:20 PM Response to Reply #1 |
2. Oh, thanks, that one will help! Hang on...what do you mean by the second |
Printer Friendly | Permalink | | Top |
catzies (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:26 PM Response to Reply #2 |
5. Your very first cell needs to have a "hard number" in it. Then the |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:30 PM Response to Reply #5 |
7. Oh ok. It's not going to need to be sequential or anything, right? |
Printer Friendly | Permalink | | Top |
Blue-Jay (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:32 PM Response to Reply #7 |
9. Whoa! Hold on! |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:38 PM Response to Reply #9 |
11. No I have a column of numbers and I want to add 1 to each cell in that |
Printer Friendly | Permalink | | Top |
Blue-Jay (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:43 PM Response to Reply #11 |
17. You'd be better off adding a new worksheet |
Printer Friendly | Permalink | | Top |
VelmaD (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:50 PM Response to Reply #11 |
19. I agree about doing a seperate sheet each month, but... |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 06:00 PM Response to Reply #19 |
20. Ah ok, I will try that on my little made-up-just-for-the-occasion one |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 06:04 PM Response to Reply #19 |
21. Whoohoo, that worked! Cool beans, thanks much for that one! |
Printer Friendly | Permalink | | Top |
VelmaD (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 06:06 PM Response to Reply #21 |
22. I ROCK! |
Printer Friendly | Permalink | | Top |
Blue-Jay (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:28 PM Response to Reply #2 |
6. I meant |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:36 PM Response to Reply #6 |
10. Thanks for the clarification , I think I gotcha! the other thing I'll try |
Printer Friendly | Permalink | | Top |
Blue-Jay (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:40 PM Response to Reply #10 |
14. OK, OK. |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 06:12 PM Response to Reply #14 |
23. Ah, ok, instead of a range with a condition....will try that, thanks! |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:45 PM Response to Reply #6 |
18. *lol* it changed everything to 1 in that column! Hee hee...thank god for |
Printer Friendly | Permalink | | Top |
NV Whino (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:20 PM Response to Original message |
3. Your problem is |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:41 PM Response to Reply #3 |
15. Oh ..I will have to check into that. It's just the first week on this job |
Printer Friendly | Permalink | | Top |
redqueen (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:25 PM Response to Original message |
4. Do you have an AutoSum (sigma) button on your toolbar? |
Printer Friendly | Permalink | | Top |
VelmaD (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:31 PM Response to Reply #4 |
8. Sigma only gives you the sum...I think you mean.. |
Printer Friendly | Permalink | | Top |
redqueen (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:39 PM Response to Reply #8 |
12. lol |
Printer Friendly | Permalink | | Top |
grannylib (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:40 PM Response to Reply #8 |
13. Yeah I've tried farting around with that and have searched the help thing |
Printer Friendly | Permalink | | Top |
VelmaD (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 05:42 PM Response to Reply #13 |
16. I am my department's Excel goddess |
Printer Friendly | Permalink | | Top |
petronius (1000+ posts) Send PM | Profile | Ignore | Fri Nov-05-04 06:24 PM Response to Original message |
24. This should do the averaging thing: |
Printer Friendly | Permalink | | Top |
DU AdBot (1000+ posts) | Fri May 03rd 2024, 07:27 AM Response to Original message |
Advertisements [?] |
Top |
Home » Discuss » The DU Lounge |
Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators
Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.
Home | Discussion Forums | Journals | Store | Donate
About DU | Contact Us | Privacy Policy
Got a message for Democratic Underground? Click here to send us a message.
© 2001 - 2011 Democratic Underground, LLC