Advertisement
Guest User

Untitled

a guest
Jul 26th, 2017
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. =SUM(
  2. MID(
  3. 0&A2,
  4. LARGE(
  5. INDEX(
  6. ISNUMBER(
  7. --
  8. MID(
  9. A2,
  10. ROW($1:$99),
  11. 1
  12. )
  13. )*ROW($1:$99)
  14. ,
  15. ),
  16. ROW($1:$99)
  17. )+1,
  18. 1
  19. )*10^ROW($1:$99)/10
  20. )
  21.  
  22. MID(
  23. A2,
  24. ROW($1:$99),
  25. 1
  26. )
  27.  
  28. INDEX(<the array>,)
  29.  
  30. =INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),)
  31.  
  32. LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))
  33.  
  34. MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)
  35.  
  36. MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10
  37.  
  38. =SUM(MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)
  39.  
  40. =SUM(MID(0&A2,LARGE(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement