Skip to content

Instantly share code, notes, and snippets.

@KhaledAHabib
Last active April 4, 2024 10:31
Show Gist options
  • Save KhaledAHabib/1b5c1d9d3ed8248e08e997a717154bcc to your computer and use it in GitHub Desktop.
Save KhaledAHabib/1b5c1d9d3ed8248e08e997a717154bcc to your computer and use it in GitHub Desktop.
NoNumbers = lambda(TextCell,TEXTJOIN("",FALSE,IF(ISNUMBER(MID(TextCell,SEQUENCE(1,LEN(TextCell)),1)*1),"",MID(TextCell,SEQUENCE(1,LEN(TextCell)),1))));
Reverse = LAMBDA(TextCell,TEXTJOIN("",FALSE,MID(TextCell,SEQUENCE(1,LEN(TextCell),LEN(TextCell),-1),1)));
PROPERSPACE = LAMBDA(Text, LET(TextUpper,MID(UPPER(Text),SEQUENCE(1,LEN(Text)),1),TextLower,MID(Text,SEQUENCE(1,LEN(Text)),1),TRIM(TEXTJOIN("",TRUE,IF(CODE(TextUpper)=CODE(TextLower),SUBSTITUTE(TextLower,TextLower," "&TextLower),TextLower)))));
Compare = LAMBDA(Range1,Range2,TEXTJOIN("|",TRUE,IF(Range1<>Range2,ADDRESS(ROW(Range2),COLUMN(Range2)),"")));
WordSearch = LAMBDA(STARTCELL,TARGETWORD,IF(OR(STARTCELL&""=LEFT(TARGETWORD),STARTCELL="?"),IF(LEN(TARGETWORD)=1,TRUE,OR(WordSearch(OFFSET(STARTCELL,-1,0),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,1,0),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,0,1),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,0,-1),MID(TARGETWORD,2,LEN(TARGETWORD))),)),FALSE));
HailstoneSeq = LAMBDA(StartNumber,[n],let(newN,IF(ISOMITTED(n),1,n),IF(StartNumber=1,newN,HailstoneSeq(IF(ISODD(StartNumber),(StartNumber*3)+1,StartNumber/2),newN+1))));
Fibonacci = LAMBDA(t_1,t_2,n,IF(n<3,CHOOSE(n,t_1,t_2),Fibonacci(t_2,mod(t_1+t_2,1000),n-1)));
FilterByRange = LAMBDA(RangeToFilter,CriteriaRange,FILTER(RangeToFilter,COUNTIFS(CriteriaRange,RangeToFilter)));
InvFilterByRange = LAMBDA(RangeToFilter,CriteriaRange,FILTER(RangeToFilter,COUNTIFS(CriteriaRange,RangeToFilter)=0));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment