Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 15, 2025
Topics: 61 / Replies: 1579
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
Reply
RE: Vlookup and transpose

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

1 year ago
Reply
RE: I need a formula to count the number of types of guests there are on each day of the week for a specific month

Hi Antony, No file attached. Click Start Upload after selecting the file(s). Phil

1 year ago
Reply
RE: New customer count

Hi Brian, Can you please supply your file/data. Regards Phil

1 year ago
Forum
Reply
RE: Can Excel call an API for row level data retrieval/validation?

Hi Martin, Yes Power Query can do this. Create a new Custom Column and for each row call your API. So if you have a column called Postcode, in y...

1 year ago
Page 3 / 110