Forum

Hi Brian, You need to construct the SQL statement and then run it, without seeing you data I can't say anything more precise. You need a connect...

Hi Ivan, No file attached. Instructions on attaching files regards Phil

Hi Robb, You can add extra clauses to an if like so: = Table.AddColumn(#"Inserted Week of Month", "Custom", each if [Dates] >= #date(2020, 2,...

Hi Ronak, See attached file that uses a very fast function to calculate grouped running totals. On the 'In Stock GRT Function' sheet are the res...

are you unable to supply a copy of your live data? Without it, the help I can offer is limited. Are you using a custom list to sort in Excel? ...

Mohamed, This is the 3rd time I have asked you to attach a workbook. Without your actual file/query/data I can not help. Phil

Aye, Please always supply a workbook with data You haven't said how you are sorting but I'm guessing it's by the AccomCode. When I type those c...

Yes that's fine, please provide an example of the xlsx file and what you want as a result. Regards Phil

Hi, Please provide a workbook containing your data and example(s) of the expected result. Phil

Hi Sholtan, As I've asked you on other posts, please supply the workbook(s). Impossible to do anything without the data this code operates with. ...

Hi Robert, The {} means it's an array formula. Excel Array Formulae I'd say the forumla(e) is(are) referencing some cells that result in #VAL...

Hi maccra, That website provides an API so you may be able to use that to get the data you need. It says that they provide tools to access th...

The problem here is the site you are accessing so anything we try is a workaround. You may need to use VBA to scrape the data. Web Scraping with V...

Hi Rebekka, How about using conditional formatting to highlight the lowest price for each part, the use some MIN functions to pull out the lowest p...

Hi Alan, Please., always supply a workbook so we don't have to recreate (incorrectly) your data, and so we can see what you are actually working wi...