Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Apr 18, 2025
Topics: 61 / Replies: 1568
Reply
RE: How to auto-populate cells

Hi Liam, What is the purpose of this? How does this problem relate to your work? Regards Phil

7 months ago
Reply
RE: Cleaning Data in Power Query

Hi Dale, No file attached. Click Start Upload after selecting the file. Phil

7 months ago
Forum
Reply
RE: Get XLSX from folder only retrieves one file

Thanks Mark. Presumably after the bank started providing the data in XLSX format you had to create a new query to load that data - separate to your...

8 months ago
Forum
Reply
RE: Training Dashboard

Hi Sridevi, If you wish to learn how to create Dashboards then you really need to take our Excel Dashboards Course. This topic isn't something t...

8 months ago
Reply
RE: Use Sumifs with the Left function

Hi David, Please supply your file so we can see what data the formula is using. Really hard to debug it without this. Also please state what re...

8 months ago
Reply
RE: Conditional Formatting breaks when sorting after a new table row has been added.

Hi Larry, No file attached. Click on the Start Upload button after selecting the file. Regards Phil

8 months ago
Forum
Reply
RE: How to use Roundup function within an existing formula

Hi Liam, If you are trying to round to 0 decimal places, your 0 is in the wrong place, use this = ROUNDUP(C5*(D5/100),0) - SUM(F6:J7) Regards...

9 months ago
Reply
RE: Extracting data from multiple Excel files

Come on dude. You ain't even trying on this one. Send an administrator. Hi Bradley, Please have some respect and patience. You are getting f...

9 months ago
Reply
RE: If statement giving "False"

Hi Steven, Can you please supply your file rather than a PDF. With the PDF I can't see what data is in the cells and I can't see all the formula. ...

9 months ago
Reply
RE: Can the actions of 2 subs be replaced/carried out in Power Query?

Hi Roger, No file is attached. After selecting the file you then need to click on 'Start Upload'. Regards Phil

9 months ago
Forum
Reply
RE: Making POST Request to get data from API in Power Query

Hi, As the URL does not change as you go through the pages of data, that data is loaded using JavaScript and unfortunately can't be scraped using P...

9 months ago
Forum
Reply
RE: Duplicates

Hi Andrew, Nothing attached. Can you please supply a file rather than a picture? Saves us having to recreate your data. regards Phil

9 months ago
Reply
RE: AVERAGEIFS with multiple conditions

Nothing attached. Click Start Upload after selecting the file

9 months ago
Reply
RE: Vlookup and transpose

Hi WW, No file attached. After you select the file click on Start Upload. Phil

10 months ago
Page 2 / 109