
Last seen: Feb 8, 2025
Initial post updated with OP message and file
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...