Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 22, 2025
Topics: 61 / Replies: 1579
Reply
RE: PowerQuery: Calculate Aging Buckets

Hi Steven, No file is attached. You have to click the Upload button to load the file. Read This First | Forum Rules and Guides | Excel Forum • M...

3 years ago
Forum
Reply
RE: If and Sum

Hi Emmanuel, You should do this with a Pivot Table - it will do the sum calculations automatically for you Excel Pivot Tables Explained • M...

3 years ago
Reply
RE: Data Validation List allowing multiple selections

Hi Rhonda, Please see this comment for a file that does what you ask Select Multiple Items from Drop Down (Data Validation) List • My Online Tra...

3 years ago
Forum
Reply
RE: Conditional Formatting - PowerBI DAX

Yes, my code already does that. Have you tried using it? regards Phil

3 years ago
Reply
RE: If condition using 2 columns

Hi Emmanuel, You're file did not upload but I could work it out from your description. This is the formula you need =IF(OR(B3="Cheryl",B3="De...

3 years ago
Reply
RE: Conditional Formatting - PowerBI DAX

Hi Glenisa, If you supplied your file that would help to see your measure and data, but without it I can only give an example of this formatting. ...

3 years ago
Reply
RE: Power query loading multiple pdf files from a folder

Hi Gary, The issue isn't that there are multiple PDF's, it's the structure in the PDF's differs. You'd have the same issue with workbooks, tables,...

3 years ago
Forum
Reply
RE: Open folders on a network using VBA

Hi Michael, Your IT Dept really should know better than to use characters like # in folder names. Can you ask them to change it? Or, can you ma...

3 years ago
Forum
Reply
RE: Extracting URL from the Webpage from multiple HTML tables

Hi Ritabrata, Html.Table only works in PBI and it requires a CSS selector to get the data from the web page. The tables on that GitHub page have n...

3 years ago
Forum
Reply
RE: How to Remove Rich Format Text from Multiple Cells

Hi Katie, Have you tried using the Format Painter in the Ribbon to copy/paste formatting from an unformatted cell over the rich text formatted cell...

3 years ago
Reply
RE: Open folders on a network using VBA

Hi Michael, It doesn't like the # in the folder name. It's not advised to use characters like # in file or folder names, can you change it? Reg...

3 years ago
Forum
Reply
RE: Vba for logistic

Hi Neda, You can use Loom to record your screen and host the video then link to it from here. If we hosted everyone's videos we'd run out of disk ...

3 years ago
Forum
Reply
RE: Get ALL Entries from a Webpage

Hi Matthias, The behaviour you describe from the webpage indicates that the loading of new data is triggered by scrolling to the bottom of the page...

3 years ago
Forum
Reply
RE: Get ALL Entries from a Webpage

Hi Matthias, PQ can't interact with a website in this way. You could use Power Automate though. You can start a browser, then send the END key ...

3 years ago
Forum
Reply
RE: How can I format the time and keep them consistent (while refreshing) on a table or on a Power Pivot table?

Jim, No file is attached. Please follow the instructions here to upload a file Read This First | Forum Rules and Guides | Excel Forum • My On...

3 years ago
Forum
Page 16 / 110