Forum Discussion
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...
- 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),""),
thanks this one also work well
1 issue is it cannot find the X number in the below. I am guess cos of the ( )
"B2K ID Deletion (x2 ID)" = came back with #VALUE! (should be 2)
each report is around 8k in rows. but even if this cannot be fixed with ( ) then anyhow this would save me a lot of time.
1 issue is it cannot find the X number in the below. I am guess cos of the ( )
"B2K ID Deletion (x2 ID)" = came back with #VALUE! (should be 2)
each report is around 8k in rows. but even if this cannot be fixed with ( ) then anyhow this would save me a lot of time.
