Forum

Hi, List.Intersect requires the lists be supplied as a list. As written above it thinks that List2 is the 2nd optional parameter equationCriteria ...

Hi, This query will insert a blank row after every 3rd row: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...

Hi, You need to double up on the double quotes inside the string, otherwise it looks to VBA like you are ending the string because there's a single...

Hi, Why do more work than you need to? If Power Query can do this then that's what I'd use. If PQ can't do it then we can look at a VBA solution. ...

You're welcome. Next time you supply the HTML just copy the entire page rather than a part of it so that errors like missing tags don't happen. ...

Hi Sholtan, As I said in the other thread, I believe your are cross posting these questions. The people who try to help you give up their own ti...

Hi Sholtan, I believe your are cross posting these questions. Please read the terms for using this forum as you are in breach If you contin...

Hi Rajsha, The HTML excerpt you provided only had 1 UL in it, but that's ok to get this working. However there are other bits of code that are m...

Hi, This looks like a job for Power Query. If you can provide some sample files with the source data then I can write a query for you. regards ...

Hi Netty, Workbook is password protected. Can't open it. Regards Phil

Hi Erdenebileg, No worries. Sorry your explanation isn't clear still. You refer to 'the expected result is to get correct values' but I don't k...

Hi Franck, The purpose of his forum and site is not to do homework for people! You can search our site and find information on everything you ne...

No worries.

Hi Matt, We need to see the source data to write any kind of query, please supply them, even just some samples. Where do you get the files? A...

Hi Sue, To use VLOOKUP the way you need requires a list that has unique values that can be looked up. So in the case of looking up the Section in C...