mackan1

Apr 19, 2023Copper Contributor

# Find number before and after "x"

I have been playing around this for a wile and cannot get it working. I currently use =MID(B2,FIND("x",B2,1),15) (but this is very basic and i have to do alot of editing as it also pulls over "X" (E...

- Apr 20, 2023check line 5:

out,IFERROR(INDEX(FILTER(vals,NOT(ISERROR(--vals)),0),1),0),

and make it

out,IFERROR(INDEX(FILTER(vals,NOT(ISERROR(--vals)),""),1),""),