Forum

Try recording a macro while saving the file manually to the address you mentioned: COMPLETED MDF FORMS 2021 Once you put that path in file explor...

The question and topic title clearly says: I need formula to calculate the maximum percentage of drop Looks like the question is in half, no...

Create a table from your data, make sure "My table has headers" check box is NOT checked. Use these queries (first query name is Headers): ...

Try encoding the url: url=Application.WorksheetFunction.EncodeUrl("https://gbconnect.sharepoint.com/sites/BUKGBGATEPROCESS/MDF/MAIDSTONE COMPLETED ...

Try this one: =MAX(IF($A$2:$A$7<OFFSET($A$2:$A$7,-1,0),IFERROR(1-$A$2:$A$7/OFFSET($A$2:$A$7,-1,0),0),0)) Array formula, so use Ctrl+Shift+Ent...

Also, for the data model when i'm trying to connect AllDataRes to AllDataR (Resource to Resource), it is connecting from AllDataR to AllDataRes. Is th...

Hi Shyam, When you expand columns, edit the M code: Instead of: = Table.ExpandTableColumn(#"Filtered Rows", "Content", {"Employment Status#(l...

Hi Gael, The easiest way is to add helper columns in the data sheet: for example, you can create a column for 3 parameters search, combining 3 colu...

Hi William, Here is an example based on: >code> (values as list) as list=> let RT = List.Generate ( ()=> [RT = values{0}, count...

No idea what you mean with ABS, but updated the formula, see above the part in red.

You can try this: =INT(A2)+IF(A2-INT(A2)<0.25,0,IF(A2-INT(A2)<0.75,0.5,1))

Hi William, Looking at: each if {[RT]} >= 10000 The curly brackets indicate a list type, normally, you cannot compare a list to a number, ...

Hi Alex, To create folders in Mac, it's not as easy as in windows. You have to check the environment: #If VBA7 then MkDir ... #Else ...

Try: =CEILING(2.8 , 3) =CEILING(2.25, 2.5)

Hi Chen, These are custom solutions, not really generic solutions that can be found in standard documentation. Custom solutions requires usually...