Forum Discussion

mackan1's avatar
mackan1
Copper Contributor
Apr 19, 2023
Solved

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...
excel
  • mtarler's avatar
    mtarler
    Apr 20, 2023
    check 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),""),
mtarler's avatar
mtarler
Silver Contributor
Apr 20, 2023
check 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),""),
mackan1's avatar
mackan1
Copper Contributor
Apr 20, 2023
that is prefect. you are truly a life saver.

Resources