Forum

Hi Sherry, I'd try using the Command Prompt rather than VBA for this. See if del "C:UsersbarneshOneDrive - HIIDocumentsHIITrainingOnboarding* - ...

Hi KS, No worries. Yes using Table.Buffer and List.Buffer are the way I'd do it too, it makes PQ much faster. Regards Phil

Hi KS, To ignore case in the TextTable you can make the text and the words you're searching for all the same case by using either Text.Lower or Tex...

HI, No file attached. After selecting the file, click Start Upload. Phil

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

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

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

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

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

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

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

No worries. Phil

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

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

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