Last seen: Dec 22, 2025
Hi Joepy, There is no easy way to scrape a website with excel. If you have access to that site databases, you can extract data with power query. ...
Well, at least in your sample file SUMPRODUCT is returning the expected results you provided, no idea what is in the real data. Let us know if you ...
Great, glad to hear that your problem is solved. Just make sure that you don't pass entire columns to the function, if there is no filter applied, ...
Hi PS-C21H, Please provide a link to all forums where you have posted this question. All the people that will try to provide an answer to your prob...
Hi Julie, Please upload a sample file, we cannot help you without seeing and testing the formulas. Thanks for understanding Catalin
What do you mean by "my macro stops"? Any macro should stop sometime... You can check if the table has more than 1 visible cell: VisibleCell...
Much better, now it's clear what you need. You have at least 2 options: you can group the Actions with Power Query by ID, adding the Adjusted Time ...
There is no attachment, please upload again. After you select a file, press the "Start Upload" button, otherwise the selected file will not be uplo...
Hi, A formula approach is too complicated. You should use a UDF to calculate those 2 parameters. Try these 2 functions: Option Explicit Fun...
Hi, Instead of writing complex codes, the easiest approach is to add a new column to your table, with a simple formula, to create the groups you wa...
Hi Anonemouse, You have to upload a sample file with dummy data, otherwise it will be very difficult to visualize your data structure. Try to cr...
Hi Colin, The problem is related to what an UDF can and cannot do, sorry I did not see that from the beginning, I was aware of this UDF limitation....
Can you provide more details? What version of excel are you using? Also, a sample file will say more than any words, please upload a sample file. (...
Hi Colin, Roy was very close, that is the correct approach, the only error was to compare rows with cells, we always should compare the same type o...
Hi Marianne, The json string is not formatted properly, Power query and other tools that can process this type of data will not be able to process ...