Advertisement
Guest User

Untitled

a guest
Jul 19th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. =ARRAYFORMULA(
  2. IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)02")))=18,
  3. REGEXEXTRACT(A2:A&"", "00(.*)02"),
  4. IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)02")))=18,
  5. REGEXEXTRACT(B2:B&"", "00(.*)02"),
  6. IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)02")))=18,
  7. REGEXEXTRACT(C2:C&"", "00(.*)02"),
  8. IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)15")))=18,
  9. REGEXEXTRACT(A2:A&"", "00(.*)15"),
  10. IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)15")))=18,
  11. REGEXEXTRACT(B2:B&"", "00(.*)15"),
  12. IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)15")))=18,
  13. REGEXEXTRACT(C2:C&"", "00(.*)15"),
  14. IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)10")))=18,
  15. REGEXEXTRACT(A2:A&"", "00(.*)10"),
  16. IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)10")))=18,
  17. REGEXEXTRACT(B2:B&"", "00(.*)10"),
  18. IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)10")))=18,
  19. REGEXEXTRACT(C2:C&"", "00(.*)10"),
  20. IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)11")))=18,
  21. REGEXEXTRACT(A2:A&"", "00(.*)11"),
  22. IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)11")))=18,
  23. REGEXEXTRACT(B2:B&"", "00(.*)11"),
  24. IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)11")))=18,
  25. REGEXEXTRACT(C2:C&"", "00(.*)11"),
  26. IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)")))=18,
  27. REGEXEXTRACT(A2:A&"", "00(.*)"),
  28. IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)")))=18,
  29. REGEXEXTRACT(B2:B&"", "00(.*)"),
  30. IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)")))=18,
  31. REGEXEXTRACT(C2:C&"", "00(.*)"),
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42. ))))))))))))))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement