⚠️ This page is a Work in Progress
| Formula | Result |
|---|---|
=FILTER(A2:A,B2:B=TRUE) | Generates a list of elements from A, but only where the element to right (in B) is TRUE |
=FILTER(<MyBigList>,ISNA(MATCH(<MyBigList>,<ShorterList>,0))) | Generates a list of all the elements in MyBigList that aren't present in ShorterList |
=iferror(VLOOKUP(A2,OtherSheet!$A$2:$B,2,false),false) | Looks up the value in A2 and returns the 2nd item in its relative row (where A2 == the item in the 1st column) |
=TEXTJOIN("\n",TRUE,ARRAYFORMULA(REGEXREPLACE(SPLIT(TEXTJOIN(",",TRUE,ARRAYFORMULA(REGEXREPLACE(C3:3," ",""))),","),"^",TEXTJOIN("",TRUE,REGEXREPLACE(B3," ","")," --> ")))) | (WIP) generate mermaid code from a single parent and children, to merged together to form a full flowchart |