Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: SUMIF Current Month equals Dates in Range

    Thanks, that works!
  2. SUMIF Current Month equals Dates in Range

    My SUMIF isn't working, and I'm wondering what I need to do, or if an alternative is needed. Basically, I need to total up some profits if they were earned during the current month, whatever that...
  3. Re: How to combine totals for a sheet with multiple entries for the same thing

    That is fine, thanks Sandy
  4. Re: How to combine totals for a sheet with multiple entries for the same thing

    Thanks that seems to help, but one other problem is that I have a lot of data where the player didn't score any goals for a particular season. Is it possible to remove or filter these results in...
  5. Re: How to combine totals for a sheet with multiple entries for the same thing

    It is only 22 columns. 21 seasons + 1 player column.
  6. How to combine totals for a sheet with multiple entries for the same thing

    I have a large sheet with soccer players & the number of goals they have scored each season (each column is 1999-2000, 2001-2002, etc. up to 2019-2020). The players names are often duplicated down...
  7. How is it possible for the same exact value in one cell to fail my conditional formatting while elsewhere it doesn't?

    Here is what I'm trying to do.

    A meeting or documentation turn-in needs to be scheduled for a certain date & be held, otherwise the cell where the date goes turns red and bold yellow font. I use...
  8. Re: Conditional Formatting contradicting formula

    Update: It's working now. The way I fixed the earlier problem was by re-arranging the cells in the reference sheet to all be in the 1st row.
  9. Conditional Formatting contradicting formula

    Gee, my favorite topic! Conditional formatting is kicking my *** again.

    Problem Statement: My conditional formatting formula is applying formatting to the correct & incorrect cells, all except...
  10. Re: UserForm TextBox.Value type mismatch with variable

    One more thing that I should mention. When I hit the Stop button in the VBE, it is causing Excel to crash. Any ideas why?
  11. UserForm TextBox.Value type mismatch with variable

    I've got a simple script that is giving me lots of pain. I am simply trying to validate the number entered into my first TextBox to ensure that there is not a duplicate of a job number for a...
  12. Re: Need a combinations formula for possible outfits

    I have tried modifying another formula:...
  13. Re: Need a combinations formula for possible outfits

    Also, I'm trying to make the full list of all the combinations using a formula. I have found a good formula that works with two columns, and am trying to update it to work with five columns....
  14. Need a combinations formula for possible outfits

    I need an excel spreadsheet that shows all the available combinations for a wardrobe. I think I have the logic right, but need a confirmation if this is right.

    List of wardrobe items: ...
  15. Can this scenario be modelled within Excel?

    The purpose is to ensure that an expected number of new clients will be served by a sales representative on schedule. Normally, you hire sales reps and then get clients, but for the purposes of...
  16. Replies
    3
    Views
    115

    Re: Return Positive Value of SUMIF

    Another neat trick is to put a - in front of your Sumif. So =-SUMIF(U5:U91, "2", N5:N91)
  17. Re: Count number of Employee base on schedule

    Do you need me to upload the workbook? Alternatively, if you just type 12:00 AM in F2, then 12:30 AM in G2, you can drag the 2 cells across to 11:30 AM, then repeat that process starting with 12:00...
  18. Replies
    30
    Views
    650

    Re: keyboard Shortcut for the character

    As an aside, there is a non-Excel solution to this. You would need to understand how to use AutoHotkey or own, say, a programmable mouse. Then you could run a macro when you please.
  19. Replies
    30
    Views
    650

    Re: keyboard Shortcut for the character

    Actually, I see that might not work as you intended. Just re-read your post. You could type it with the parentheses and then go back and delete them, but that still wouldn't quite fix it. I'll see...
  20. Replies
    30
    Views
    650

    Re: keyboard Shortcut for the character

    In your Autocorrect options, put the keyboard shortcut in ()'s, then type the 1/2 as normal.

    Like this: https://i.imgur.com/RCIhhSK.jpg
  21. Re: Count number of Employee base on schedule

    Something like this?
    https://imgur.com/y2PSiQ5
    https://imgur.com/y2PSiQ5https://i.imgur.com/MvsBgpH.jpg
  22. Replies
    5
    Views
    215

    Re: ListBox Change Selection (VBA)

    I just tried that, but no luck.
  23. Replies
    5
    Views
    215

    ListBox Change Selection (VBA)

    This seems like it is frustratingly simple, but I've had no luck with getting my ListBox to deselect or even change its current selection.
    My ListBox is populated with all the tabs in the workbook...
  24. Re: How to Calculate Number of Sales Reps needed based on Expected Clients

    Last call
  25. Re: How to Calculate Number of Sales Reps needed based on Expected Clients

    Anyone?
Results 1 to 25 of 107
Page 1 of 5 1 2 3 4