LinkBack URL
About LinkBacks
please, chosen 4 digits
* decrease by 9999 and add by
* 9999
the leftovers left the macro does not consider
* only the last 4 digits
* I'll put lots of draws the macro has to do automatic
https://www.excelforum.com/attachmen...1&d=1556890084
please, chosen 4 digits
* decrease by 9999 and add by
* 9999
the leftovers left the macro does not consider
* only the last 4 digits
* I'll put lots of draws the macro has to do automatic
https://www.excelforum.com/attachmen...1&d=1556890084
No need for macros. In F6:
=ABS(9-A6)
then drag across to I6 and then drag down to I10.
In K6:
=MOD(INT(($A6*1000+$B6*100+$C6*10+$D6+9999)/10^(4-COLUMN(A:A))),10)
then drag across to N6 and then drag down to N10.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Ok,PAULEY great job, congratulations, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks