dommmm
New Member
- Joined
- Feb 6, 2020
- Messages
- 10
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
Hi,
I'm wondering how best to approach this...
The formula I have in I2 is:
=IF(RIGHT(H2,5)="00000",IF(ISERROR(MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),H2,MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),"")
Basically - if the number in column H ends with 5 zeros, then I want it to find return the number (without the preceding - ) in F after "LOCDIFF" . It works fine until there's 2 "LOCDIFF" (the highlighted ones)
(the ISERROR copes with any that don't have LOCDIFF in F)
Advice much appreciated as it's giving me a headache!
I'm wondering how best to approach this...
The formula I have in I2 is:
=IF(RIGHT(H2,5)="00000",IF(ISERROR(MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),H2,MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),"")
Basically - if the number in column H ends with 5 zeros, then I want it to find return the number (without the preceding - ) in F after "LOCDIFF" . It works fine until there's 2 "LOCDIFF" (the highlighted ones)
(the ISERROR copes with any that don't have LOCDIFF in F)
Advice much appreciated as it's giving me a headache!