Forum

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

Hi, It'll be easier to do if you can supply the url of the page rather than just having a fragment of the age to work with. regards Phil

Hi Riste, Why not rearrange your source data into a single table. Then create 2 pivot tables from the same source, that way you can connect the sl...

Hi Chris, no attachment. Regards Phil

no worries.

Hi Ahmad, IF stops evaluating when it finds a True result so you can do away with the AND functions and simplify it to: =IF(A2<3,"'0-3", IF(A...

Hi Peter, Please see attached file. On the 'Week Commencing' sheet, C7 uses a drop down list and conditional formatting rules to change the colour...

Hi Peter, You might be able to use a data validation list or a spin button control. Please supply your workbook so we don't have to recreate eve...

Hi Yvonne, No attachment. There's a video here showing how to attach files Regards Phil

Hi Graham, Not quite following why you can't use formulae, you need to copy/paste the values? When you add a row to the table the formulae in the ...