Forum

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

Hi m r, Attached is a solution using Power Query. I also did one with formulae, different to Purfleet. You can't have too many options. To ext...

🙂

Hi David, Change these p tags to span and insert a br tag between the last 2 lines: .htmlbody = .htmlbody & "<span style=""font-family:ar...

Hi Bill, This is proving to be very difficult to implement. Google results are not in a fixed format. Not only do the results vary by where you a...

You're welcome David.

Hi Nesha, I'm still not sure you are accessing the file(s) as I mean. With the OneDrive app installed on your PC you will be able to access file...

You're welcome.