Forum

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

No worries. That's why I needed the whole page so I could count things like that 🙂

Hi Chris, Using XLOOKUP you can create a dynamic DV list with this formula =XLOOKUP("mouse",Table1[animal],Table1[test],,,1):XLOOKUP("mouse",Tab...

Hi Erdenebileg, I'm not sure I've totally understood everything because you mention in Step 1 finding a percentage charge based on number of people...

Hi Rajsha, If it's not publicly accessible or requires a login, can you at least view the page source code and copy/paste that into a text file. ...

Hi Ahmad, range_lookup defaults to True which means VLOOKUP will look for an approximate match. This is what you want in this scenario because you...

Hi Chris, You can use the Filter function for this: =FILTER(Table1[data1]:Table1[data3],((Table1[animal]="cat")*(Table1[test]="test 2"))) Reg...