LinkBack URL
About LinkBacks
b.yoxall 
The formula I started with was
=SUMPRODUCT(MID(A2, RowVec(1, LEN(A2)), 1) * 2^RowVec(LEN(A2) - 1, 0))
... but that uses a UDF. INDIRECT is compact but volatile.
The formula I started with was
=SUMPRODUCT(MID(A2, RowVec(1, LEN(A2)), 1) * 2^RowVec(LEN(A2) - 1, 0))
... but that uses a UDF. INDIRECT is compact but volatile.
Last edited by shg; 11-09-2017 at 01:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks