Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

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

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border:...
  2. Re: Sum numbers using two row and sum the numbers greater then 0 using row 1 as the default

    You're welcome.
  3. 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.


    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  4. 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. 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. Replies
    13
    Views
    2,073

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

    I refreshed, and refreshed...to no avail.
  7. Replies
    13
    Views
    2,073

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

    Excel 365 Insider Fast 1910 12126.2000
  8. 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. Replies
    13
    Views
    2,073

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

    Thanks for your reply, Allan.

    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. Replies
    13
    Views
    2,073

    NHL.com website; How to get tables into PQ

    Can someone please help me?

    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. 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. 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. 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. 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. 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. 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/)...
  17. Re: Recall a whole table based on a selected cell value

    You can upload sample data using the HTML Maker. https://www.mrexcel.com/forum/excel-...ins-links.html
  18. 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. 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. Replies
    5
    Views
    220

    Re: Editing MP3 Tags

    You're welcome. Bonne chance.
  21. Re: Can someone please help me understand a formula from an ExcelisFun video?

    You betcha. Check out how FILTER works.

    https://youtu.be/2kvPdv_nvbM
  22. Re: Can someone please help me understand a formula from an ExcelisFun video?

    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. 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. 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. 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 2 3 4