# Search:

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

Page 1 of 5 1

1. ## Thread: SUMIF Current Month equals Dates in Range

by gravanoc
Replies
4
Views
112

### Re: SUMIF Current Month equals Dates in Range

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

by gravanoc
Replies
4
Views
112

### 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. ## Thread: How to combine totals for a sheet with multiple entries for the same thing

by gravanoc
Replies
9
Views
108

### Re: How to combine totals for a sheet with multiple entries for the same thing

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

by gravanoc
Replies
9
Views
108

### 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. ## Thread: How to combine totals for a sheet with multiple entries for the same thing

by gravanoc
Replies
9
Views
108

### 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. ## Thread: How to combine totals for a sheet with multiple entries for the same thing

by gravanoc
Replies
9
Views
108

### 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. ## Thread: How is it possible for the same exact value in one cell to fail my conditional formatting while elsewhere it doesn't?

by gravanoc
Replies
1
Views
82

### 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...

by gravanoc
Replies
2
Views
131

### 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.

by gravanoc
Replies
2
Views
131

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. ## Thread: UserForm TextBox.Value type mismatch with variable

by gravanoc
Replies
3
Views
106

### 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. ## Thread: UserForm TextBox.Value type mismatch with variable

by gravanoc
Replies
3
Views
106

### 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. ## Thread: Need a combinations formula for possible outfits

by gravanoc
Replies
3
Views
143

### Re: Need a combinations formula for possible outfits

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

by gravanoc
Replies
3
Views
143

### 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. ## Thread: Need a combinations formula for possible outfits

by gravanoc
Replies
3
Views
143

### 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. ## Thread: Can this scenario be modelled within Excel?

by gravanoc
Replies
0
Views
126

### 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. ## Thread: Return Positive Value of SUMIF

by gravanoc
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. ## Thread: Count number of Employee base on schedule

by gravanoc
Replies
3
Views
101

### 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. ## Thread: keyboard Shortcut for the ½ character

by gravanoc
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. ## Thread: keyboard Shortcut for the ½ character

by gravanoc
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. ## Thread: keyboard Shortcut for the ½ character

by gravanoc
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. ## Thread: Count number of Employee base on schedule

by gravanoc
Replies
3
Views
101

### 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. ## Thread: ListBox Change Selection (VBA)

by gravanoc
Replies
5
Views
215

### Re: ListBox Change Selection (VBA)

I just tried that, but no luck.
23. ## Thread: ListBox Change Selection (VBA)

by gravanoc
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...

by gravanoc
Replies
4
Views
208

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

by gravanoc
Replies
4
Views
208

### 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