daily pastebin goal
50%
SHARE
TWEET

Untitled

a guest May 17th, 2018 99 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. JPMCC 2012-1 A1
  2.  
  3. Prepay %
  4. Loss %
  5. Credit Support
  6. ETC...
  7.  
  8. MLMTI 2014-6 B4
  9.  
  10. Prepay %
  11. Loss %
  12. Credit Support
  13. ETC...
  14.    
  15. JPMCC 2012-1 A1
  16. MLMTI 2014-6 B4
  17.    
  18. B1: =FIND(" ", A1)
  19. C1: =LEFT(A1, B1 - 1)
  20.    
  21. D1: =EXACT(UPPER(C1), C1)
  22.    
  23. E1: =FIND(" ", A1, B1 + 1)
  24. F1: =MID(A1, B1 + 1, E1 - B1 - 1)
  25.    
  26. G1: =LEFT(F1, 4) - 0
  27.    
  28. H1: IFERROR(IF((B1+E1+LEN(C1)+LEN(F1)+G1+D1)*0=1,"",A1),"")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top