LinkBack URL
About LinkBacks
123 123---- B2: =FlyingDays(A2) 345 --345-- x7 123456- x15 -234-67 1234567 1234567 x 1234567
Please Login or Register to view this content.
123 123---- B2: =FlyingDays(A2) 345 --345-- x7 123456- x15 -234-67 1234567 1234567 x 1234567
Please Login or Register to view this content.
Last edited by shg; 07-20-2014 at 03:18 PM.
Entia non sunt multiplicanda sine necessitate
This looks great. I can test it on Monday. I don't have a pc right now. But it looks like i save the macro and then place the formula all the the way down a column. Did I understand this correctly?
Looks very cool.
Thanks
Yup -- open the VBE, Insert > Module, paste the code there.
You're welcome.
formula option unfortunately it gives missing in reverse order!
=IF(A1="",1234567,IF(LEFT(A1)="x",SUBSTITUTE(7654321-SUMPRODUCT(MID(A1,COLUMN(INDIRECT("b"&":"&CHAR(64+LEN(A1)))),1)*10^(MID(A1,COLUMN(INDIRECT("b"&":"&CHAR(64+LEN(A1)))),1)-1)),0,"")+0,A1))
x1257 x234
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
revised formula
=IF(A1="","1234567",IF(LEFT(A1)="x",SUBSTITUTE(1234567-SUMPRODUCT(MID(A1,COLUMN(INDIRECT("b"&":"&CHAR(64+LEN(A1)))),1)*10^(8-MID(A1,COLUMN(INDIRECT("b"&":"&CHAR(64+LEN(A1)))),1)-1)),0,""),A1&""))
x123 4567 x345 1267 x1257 346 x13456 27 x234 1567 1234567 x1234567 367 156 x156 2347
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks