Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 4, 2026
Topics: 61 / Replies: 1588
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

2 years 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...

2 years 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

2 years ago
Reply
RE: AVERAGEIFS with multiple conditions

Nothing attached. Click Start Upload after selecting the file

2 years ago
Reply
RE: Vlookup and transpose

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

2 years 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

2 years ago
Reply
RE: New customer count

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

2 years 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...

2 years ago
Reply
RE: Divide time to get percent

Hi James, If you put 0:1:00 in a cell and 0:1:30 in another cell then divide the former by the latter, you get 0.667. What have you tried that h...

2 years ago
Reply
RE: Divide time to get percent

Hi James, Can you give an example and the expected result please? You can't divide 'times' as such. What is 12.30am divided by 3.45pm? Makes n...

2 years ago
Reply
RE: Highlight Y-O-Y like Min and Max in a chart?

Hi Brenda, Nothing is attached. After you select the file you need to click Start upload to load it to the site. Phil

2 years ago
Reply
RE: Another query about extracting unique records

Hi Ivan, Nothing is attached. After you select the file click Start Upload to upload it. Phil

2 years ago
Forum
Reply
RE: Power View

Hi Dixon, The video you linked to is about Power Pivot so I'm not following how that relates to your query about Power View. Sorry I don't have 48...

2 years ago
Forum
Reply
RE: Infobulle

Hi, Please be specific (give an example) about what type of 'button' you mean and in what context. Regards Phil

2 years ago
Page 4 / 110
0