Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =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
- )
- MID(
- A2,
- ROW($1:$99),
- 1
- )
- INDEX(<the array>,)
- =INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),)
- LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))
- MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)
- 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
- =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)
- =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