Search:

Type: Posts; User: fburg; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    280

    Happy Belated July 4th to you too. Great time...

    Happy Belated July 4th to you too.

    Great time here on the Jersey Shore.

    What - no macro-based spreadsheet with exploding fireworks?


    Fred
  2. Maud, I just tried your new version. Very...

    Maud,

    I just tried your new version. Very cool.

    I almost didn't see the narrow button next to the Snap button. Could be worsening eye sight with advancing age.

    Very cool that the grid allows...
  3. Hi Maud, You're right. I had thought the...

    Hi Maud,



    You're right. I had thought the error msg would come up as soon as the totals showed other than 100%. I didn't include "less than" 100% because that's certainly possible while you're...
  4. I knew Maud could do it! A few comments: - I...

    I knew Maud could do it!

    A few comments:
    - I changed the # months to 6, decreased one of the month's allocation, and put the remaining % in month 6. I observed that the current allocations did...
  5. Attached is a spreadsheet that only takes into...

    Attached is a spreadsheet that only takes into account a change to the # of months over which the sales are counted. This looks like it should work but I only did limited testing. You should...
  6. Replies
    4
    Views
    120

    Hi, I'm attaching a workbook with a...

    Hi,

    I'm attaching a workbook with a suggestion. Take a look.

    Look at the columns that have row 1 shaded in yellow - that's what I added.
    - col L just calculates the number of days for the...
  7. I'm looking for the post I just made in response...

    I'm looking for the post I just made in response so I could edit it but can't find it. So I'll try again.

    NOTE: I just found my previous post and deleted it. This new post is more direct.

    In...
  8. [SOLVED] Zeddy - I see you came to a fork in the road and...

    Zeddy - I see you came to a fork in the road and took it!

    My favorite Yogiism is about him going into a pizza shop and ordering a whole pie. The waiter asks should the pie be cut into 6 slices or...
  9. Thread: Year Change

    by fburg
    Replies
    3
    Views
    142

    Another approach, although a little bit more...

    Another approach, although a little bit more dangerous, is to change your system clock to be sometime in 2015. Doesn't matter when. I've done that on a few occasions. BUT YOU HAVE TO REMEMBER TO...
  10. Hi Norm, Thanks for the detailed explanations....

    Hi Norm,

    Thanks for the detailed explanations.

    As I said at the very beginning of my posts on this thread (the one replying to the OP), I often do things the hard way with array formulas and...
  11. Hi Norm, Thanks for the info and learning...

    Hi Norm,

    Thanks for the info and learning opportunities.



    Then this "feature" is even stranger. I just happened to choose the Data drop down first and didn't even bother with Month or others...
  12. Hi Norm, As I said in my original response, I...

    Hi Norm,

    As I said in my original response, I don't use PT's much but I know they're a powerful tool. So I'm having a little trouble with your responses in your previous email.

    First let me...
  13. Well done! That's why I didn't even take a...

    Well done!

    That's why I didn't even take a shot at this - no way I could do this. But I sure learned a lot.

    Question: I noticed that the months go from 2 to 10 (presumably Feb to Oct) in the...
  14. Replies
    3
    Views
    799

    here's a link to new features in Excel 2016:...

    here's a link to new features in Excel 2016:
    http://new.office-watch.com/2016/excel-2016-jan-2016-update-new-chart-and-functions/

    I looked at the article. I don't do much charting, so those...
  15. Hi Check Marc, I know someone here will be...

    Hi Check Marc,

    I know someone here will be able to help with the solution but I would suggest using Excel's Pivot Table (PT) feature. It will take care of all/most of what you asked about.

    A PT...
  16. Replies
    7
    Views
    282

    Yay for learning! about the only thing I can...

    Yay for learning!

    about the only thing I can take credit for on the R1C1 (or called just RC?) addressing is not forgetting something that I just did a few days earlier!

    I had replied to another...
  17. Replies
    7
    Views
    282

    Another way to deal with the changing columns,...

    Another way to deal with the changing columns, instead of using CHOOSE where the column letters are specified explicitly, is to use INDIRECT with R1C1 type of addressing.

    For example, ...
  18. Replies
    7
    Views
    626

    that makes life even simpler. Thanks. Fred

    that makes life even simpler. Thanks.

    Fred
  19. I don't know if you saw my second post. There...

    I don't know if you saw my second post.

    There is no need to move the data to start in col E if you use the revised formula of my second post.

    You mentioned in post #3 that you wanted a single...
  20. OK, it's 5 minutes later and the brain is...

    OK, it's 5 minutes later and the brain is starting to function.

    To adjust for the -4, try:

    =SUM(INDIRECT("R4C" & COLUMN()-IF(COLUMN()<5,COLUMN()-1,4),FALSE):INDIRECT("R4C" & COLUMN()-1,FALSE))...
  21. how about a formula like: =SUM(INDIRECT("R4C"...

    how about a formula like:

    =SUM(INDIRECT("R4C" & COLUMN()-4,FALSE):INDIRECT("R4C" & COLUMN()-1,FALSE)) / 4

    Put this in row 5 (or some other row) and fill across.

    The only (?) problem with the...
  22. Replies
    7
    Views
    626

    If I'm understanding the overhead, it seems that...

    If I'm understanding the overhead, it seems that your code is opening Excel and maybe even creating a workbook for every problem the student does. Could we take care of starting Excel when we open...
  23. Replies
    7
    Views
    626

    Hi Paul, Doesn't seem like a lot of code to...

    Hi Paul,

    Doesn't seem like a lot of code to me.

    A couple of quick things:
    - I gave the #NAME error as an example. I noticed you "trapped" that explicitly. How can we be more general?
    - I also...
  24. Replies
    7
    Views
    626

    Use Excel to get result

    Hi All,

    Is it possible to call Excel from another program to pass it a string and get back results?

    We have some VBA code in PowerPoint and Word. It accepts some user inputs in the form of an...
  25. Replies
    24
    Views
    1,141

    Vincenzo - you can play this 2 ways. If you...

    Vincenzo - you can play this 2 ways.

    If you want to look like the hero all the time, don't tell her about the Lounge and you're set for life.

    If you don't want to bother with us (old) foggies,...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4