Last seen: Jul 8, 2026
Ah, I see. If your Excel version supports LAMBDA (and helper functions), you can put AGGREGATE in a BYROW/LAMBDA function to make it spill as demonstr...
Oh, but this is completely different. I focused on the desired pivot table and ignored the intermediate table as much of the information is not needed...
You might want to try PQ that's part of PowerBI. It has a more advanced way to connect to web-sites. I took your link and could extract a table that h...
If I understand you correctly you want to be able to always highlight alternating groups in a table. Filtered or unfiltered. Thus, when you filter ...
The MDY or DMY setting depends on how the source data looks like. Then Excel knows how to "translate" that to your local date format. Since the dates ...
I imported to the CSV file (legacy text wizard) and indicated that the second column contained dates in the MDY format and the third in the DMY format...
Hi Pamela, Let's say the October 4 date sits in A1, then you can use the following formula to perform the calculation you want: =(EOMONTH(A1,0)-...
The attached PQ solution isn't going to win a prize for being the most beautiful piece of art, but it seems to work. The last two columns with amounts...
Yeah, forgot to mention that. Noticed your data had one negative in it. Assumed that is was a mistake of some sort, as there really isn't something li...
Thanks, but I don't really see how the txt file relates to the desired output.
Perhaps not the most elegant way but you can create a second pivot table that shows each of the values as a % of the column total. Then you can point ...
Hi Rashid, Please try attaching the file(s) again. Don't forget to press "Start upload" before you submit your reply. Riny
Hi Loren, Enter this formula in M2 to transform the estimated hours: =INT(I2)/24+MOD(I2,1)*100/1440 Copy it all the way down and one column t...
Not sure that I have understood your intentions, but the attached file contains some queries that connect to a folder containing your three files. It ...
Hi, You could create a function that removes all empty columns for you. A similar question came up several years ago in the Microsoft Tech Communit...