Forum

Hi Leslie, In that sample file, the header name had a trailing space so it was actually 'DOW ' not just DOW. Remove that trailing space and it wor...

Hi Maarten, Did you mean to attach files? You need to click the Start Upload button after selecting the files. Phil

Hi, Can you give an explanation of what it is trying to do and what you want. It looks like it is trying to get some info about Groups on Yammer...

Hi Faeza, No file attached. Regards Phil

Hi Leslie, Please attach your query too. Phil

Hi Steven, As I noted in the PBI forum, the date issue is due to them being in US format and you need to change them using Change Type -> Using ...

Hi, You can't tell Excel to only check for changes every x seconds. If you are using worksheet change events like this, they will trigger when the...

You're welcome.

Hi Steven, This is cross posted to the PBI Community Forum Please read If you are going to cross post please tell us and link to it so you don...

Hi, VLOOKUP will only work on data that is sorted. If you have XLOOKUP you can use that on unsorted data though WorksheetFunction.XLookup( Ra...

Hi Steven, If you find you have problems with this when used on real data, please attach a workbook with a sample table of that real data. If yo...

Hi Steven, It should be fine, I tested for that scenario when I wrote the query. Please see attached. Regards Phil

Hi Nesha, If you are all using MS 365 but not using OneDrive to sync files to the PC then you are not using the system to its full potential. It w...

Hi Huy, The issue is that VLOOKUP requires the lookup values to be sorted in ascending order. The table you were using for lookup had the values i...

Hi Steven, Please see attached file for PQ solution. If you find you have problems with this when used on real data, please attach a workbook wi...