Forum

Hi Syed, If the aim is to get the string West Broad Hyundai from the string New Site - West Broad Hyundai on Sheet 2 then just use this formula in ...

Hi Raj, Can you please explain what you mean by dates prior to 1900 are not loading properly. Looking at your file I see a column of dates. But...

Hi Maurizio, If you use Power Query it gets the data without a problem - see attached file. Regards Phil

Hi Clive, Please provide your workbook with query and some sample CSV files. Regards Phil

Hi Miguel, So your problem is resolved? regards Phil

Hi Simon, The use of Table.Buffer isn't very well explained by Microsoft. Sometimes it makes things quicker, sometimes it doesn't. In your case a...

Hi Nathalie, Please supply your workbook with code so that we don't have to recreate everything from scratch. regards Phil

Hi Alan, I would say that I understand that formula because I understand how each of the functions in it works, or at least I understand the parame...

No worries.

OK no worries. Glad to hear you got it figured out

Hi Johan, The Grouped Running Total function requires 2 parameters but you were only supplying one. You need to supply the list of values to sum a...

Hi Adam, Can you please supply some sample data in an Excel file. Thanks Phil

Hi Jacek, After loading the table you can check the value of the NamedRange then use Table.RemoveRows to clear the table but leave the columns inta...

Hi, I'm not aware of a published limitation on the number of queries Power Query specifications and limits - Excel (microsoft.com) I imagine ...