Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    3
    Views
    145

    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/)...
  2. 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
  3. 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...
  4. Replies
    13
    Views
    298

    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)
  5. Replies
    5
    Views
    152

    Re: Editing MP3 Tags

    You're welcome. Bonne chance.
  6. 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
  7. 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,...
  8. Replies
    5
    Views
    152

    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...
  9. Replies
    1
    Views
    67

    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...
  10. Replies
    4
    Views
    88

    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.
  11. Replies
    4
    Views
    88

    Re: Identifying Trends by Date - Countif

    Identifying streaks is a challenging operation in Excel. Please review this thread and see if it sparks any ideas for you. I tried doing this with function COUNTIFS but it bogged down the CPU, so I...
  12. Re: extract a list of colour combinations from a table

    The new functions are immensely powerful. And they are coming to a computer near you someday!

    Watch MrExcel's videos, like this one and the subsequent ones about some of the new functions, UNIQUE,...
  13. Re: Excel 2016 minimizes when dragging between dual monitors (I think this occured after an Excel update)

    I suspect it's a MSWindows deal - it's not unique to Office. Lots of programs behave like that, I have just discovered.

    Just toss your windows to the top of the target screen. It's hardly a burden.
  14. Re: Excel 2016 minimizes when dragging between dual monitors (I think this occured after an Excel update)

    Well that's peculiar. I get the same. Dragging the Excel window to a another monitor makes Excel a shrinked up window. Going each direction does the same. My only solution is to avoid letting go of...
  15. Re: extract a list of colour combinations from a table

    Excel has new functions in Excel365 Insider. They do exactly what you wish and they do it in a jiffy. They are dynamic and they are functions that 'spill'.

    <b></b><table cellpadding="2.5px"...
  16. Re: Calculation bottleneck in a large financial model

    You're welcome. Come back and report on your outcomes.

    I neglected to respond to your other enquiry. I don't know about any subroutines that identify formula speed. But I do know this procedure...
  17. Re: Calculation bottleneck in a large financial model

    My understanding is that using ExcelTables speeds up calculation.

    Not all volatile functions slow things down. In fact, I learned the other day that, in my particular application at least, using...
  18. Replies
    2
    Views
    104

    Re: count colored cells

    You can use function COUNTIFS by mirroring all the conditions that trigger the CndFrmt. In other words, if AVG Cost is CndFrmt green because it meets a certain condition and LOC% is yellow because it...
  19. Re: SUMIF and VLookup/Index match for consolidating Data

    Welcome to the forum.

    Well, I think you need a table of accounts and knowledge about several Excel functions like SUMIFS. All that linking and manual pointing every month is a sinful waste of...
  20. Re: How to test whether a single-cell range is a dependent (first-order, second-order, ... n-th order) of a given range (single cell or multiple)?

    Welcome to the forum.

    While I have no answer to your specific question about determining calculation duration, I do have suggestion: upgrade your software. Excel365 has a new calculation engine...
  21. Re: NEED HELP: Countif tie breaker with multiple tie breaker criteria

    Following these threads and their links might help.

    https://www.mrexcel.com/forum/excel-questions/1021796-ranking-multiple-tiebreakers.html?highlight=tiebreakers...
  22. Replies
    4
    Views
    187

    Re: Cleaning up Conditional Formatting

    It sounds as though CondFrmt is the culprit. Delete all the rules and apply them again en masse across the proper ranges. In my experience all that copying, moving, inserting and deleting of rows &...
  23. Re: Golf majors; retreive data from Wikipedia articles

    Sandy, thanks for your dedication here. I was able to create a column under the field Select containing all the dates from 1860 onward. When the Query was invoked, some of the webpages reported an...
  24. Re: Golf majors; retreive data from Wikipedia articles

    Thanks Sandy. I had to alter and manipulate all kinds of things in the query, but I finally got 448 dates for golf's four major tournaments into one table. Not all years' webpages for each tourney...
  25. Re: Sorting, grabbing, and averaging a lot of data into a few cells by date...

    The new functions in Excel 365 make quick work of this type of task. A PivotTable also does it in a jiffy.

    Here is the formulaic solution with Excel 365 Insider functions.

    <b></b><table...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4