Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Oct 4, 2025
Topics: 61 / Replies: 1584
Reply
RE: Dynamic Column Search for a text and return range

Hi, Your criteria are too vague. Please provide sample data and examples of the results you want. Regards Phil

1 year ago
Forum
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

1 year ago
Reply
RE: Cleaning Data in Power Query

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

1 year 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...

1 year 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...

1 year 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...

1 year 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

1 year 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...

1 year 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...

1 year 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. ...

1 year 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

1 year 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...

1 year 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

1 year ago
Reply
RE: AVERAGEIFS with multiple conditions

Nothing attached. Click Start Upload after selecting the file

1 year ago
Page 3 / 110