# Search:

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

Page 1 of 6 1

1. ## Thread: Vacation Time Formula

by DRSteele
Replies
1
Views
82

### Re: Vacation Time Formula

Welcome to the forum.

I took the time to create some sample data. Copy the formulas downwards.

2. ## Thread: Sum numbers using two row and sum the numbers greater then 0 using row 1 as the default

by DRSteele
Replies
3
Views
90

### Re: Sum numbers using two row and sum the numbers greater then 0 using row 1 as the default

You're welcome.
3. ## Thread: Sum numbers using two row and sum the numbers greater then 0 using row 1 as the default

by DRSteele
Replies
3
Views
90

### Re: Sum numbers using two row and sum the numbers greater then 0 using row 1 as the default

You can try this. Formula R6 sums the current row's monthly values and uses the prior year's values for empty months.

4. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### Re: NHL.com website; How to get tables into PQ

Yes, I was able to do that. No matter what I try, there are no other tables listed.
5. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### Re: NHL.com website; How to get tables into PQ

Sandy, I have tried over and over for months now for that website.
6. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### Re: NHL.com website; How to get tables into PQ

I refreshed, and refreshed...to no avail.
7. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### Re: NHL.com website; How to get tables into PQ

Excel 365 Insider Fast 1910 12126.2000
8. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### Re: NHL.com website; How to get tables into PQ

Thanks Sandy. All I see is everything above your Table0.

P.S. how do I add screenshots?
9. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### Re: NHL.com website; How to get tables into PQ

All that the navigator shows is a yellow folder with
https://www.nhl.com/standings/2019/league [1] and under it an item called Document. There are no tables listed....
10. ## Thread: NHL.com website; How to get tables into PQ

by DRSteele
Replies
13
Views
2,073

### NHL.com website; How to get tables into PQ

I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique?

https://www.nhl.com/standings/2019/league
11. ## Thread: Working Days Calculation w/a Twist

by DRSteele
Replies
1
Views
119

### Re: Working Days Calculation w/a Twist

Welcome to the forum.

Unless I'm missing something and assuming your NETWORKDAYS part is okay, then this should do it: =IF(A1*B1,NETWORKDAYS(A1,B1,D1:D9)+1,"")
12. ## Thread: Lag on First Data Entry after Recalc

by DRSteele
Replies
3
Views
131

### Re: Lag on First Data Entry after Recalc

Welcome to the forum.

I suggest that the calculation lag is purely a consequence of having such a large file - 195Mb is huge.

Is there any of it you can move to an external file? Better yet,...
13. ## Thread: Excel vlookup with variable information

by DRSteele
Replies
2
Views
86

### Re: Excel vlookup with variable information

This use of numerous files for each Supplier is probably not effcienet and restricts what formulas can be used. It would be better to put all the supplier information into several worksheets within...
14. ## Thread: Return all billing codes billed per customer visit

by DRSteele
Replies
11
Views
327

### Re: Return all billing codes billed per customer visit

You will need Excel 365 for function TEXTJOIN to work here. Put this in E2 and copy down.

=TEXTJOIN(", ",,IF(C2,IF((A2=\$A\$2:\$A\$10)*(\$B\$2:\$B\$10=B2),\$D\$2:\$D\$10,""),""))
15. ## Thread: Longitude Latitude Question

by DRSteele
Replies
4
Views
188

### Re: Longitude Latitude Question

If I understand correctly, what you want to do is calulate the Great Circle Distance, as in this thread

https://www.mrexcel.com/forum/excel-questions/966498-create-territories.html#post4639578...
16. ## Thread: I need new ideas

by DRSteele
Replies
3
Views
235

### Re: I need new ideas

I do. Instead of typing in your scores, use Power Query to download the data from a website. I do it every day during NHL season. The scores come from this website (https://www.hockey-reference.com/)...

by DRSteele
Replies
3
Views
175

18. ## Thread: Recall a whole table based on a selected cell value

by DRSteele
Replies
3
Views
175

### Re: Recall a whole table based on a selected cell value

Welcome to the forum.

I have Excel365 Insider, so I hope this also works in old software.

Put a DataValidation list somewhere; in my test case, it's M9. It contains the List of the names of the...
19. ## Thread: SUMProduct formula error

by DRSteele
Replies
13
Views
418

### Re: SUMProduct formula error

I have no idea what you're trying to achieve, but it looks like this should be the third argument in function SUMPRODUCT:
--((FTHomegoals+FTAwaygoals)>MV3)
20. ## Thread: Editing MP3 Tags

by DRSteele
Replies
5
Views
220

### Re: Editing MP3 Tags

You're welcome. Bonne chance.

by DRSteele
Replies
3
Views
184

You betcha. Check out how FILTER works.

https://youtu.be/2kvPdv_nvbM

by DRSteele
Replies
3
Views
184

Welcome to the forum.

1. AGGREGATE with 15 as the function_num argument is the equivalent of SMALL. But AGGREGATE is superior to SMALL here because of the options argument, which is set here at 6,...
23. ## Thread: Editing MP3 Tags

by DRSteele
Replies
5
Views
220

### Re: Editing MP3 Tags

I can't help with VBA. But there are programs that extract metadata like MP3 tags and create an Excel spreadsheet. TagScanner is a music app that can export MP3 tags as csv files. You can then...
24. ## Thread: #SPILL! error with sumifs

by DRSteele
Replies
1
Views
200

### Re: #SPILL! error with sumifs

Welcome to the forum.

Your formula creates 1.05 million answers. Notice that the only row in which it can reside is Row1; if you move it to Row2, the computer will bog down for a while and...
25. ## Thread: Identifying Trends by Date - Countif

by DRSteele
Replies
4
Views
120

### Re: Identifying Trends by Date - Countif

I'm glad you got something workable. Keep in mind there may be more than one date for each consecutive streak. There might be several times that a streak is four, or three or whatever.
Results 1 to 25 of 150
Page 1 of 6 1