Forum Discussion
jwenzCHUBB
Jun 10, 2022Copper Contributor
Excel Loops to find Integers in a Sequence
Hello Helpful People, I need to apply an excel formula to a string of data. Here is a screenshot of what I am working with: In the sheet, Cell B2 will be automatically input as we...
Patrick2788
Jun 10, 2022Silver Contributor
This might work:
=LET(s,SEQUENCE(LEN(B4)-3),u,UNIQUE(FIND("$",B4,s))+1,m,UNIQUE(FIND("m",B4,s)),d,m-u,p,MID(B4,u,d),per,TEXT(p/B2,"(0%)"),TEXTJOIN("/",1,DOLLAR(p,0)&"m "&per))