Forum Discussion
Working with Binary numbers BASE(..., 2, 7) and bit operations BITXOR, BITAND
I recently came across an Excel challenge from Chinmay Amte on LinkedIn and I plan to post my solution here because it contains some 'off the beaten track' techniques that might be of some interest. ...
Combinations is too complex for me, make the bookmark to play one day.
As for the binary logic long ago I used it to check if the character is in English alphabet or in digits
ABC = LAMBDA(chr,
IFERROR(
BITOR(chr, 48),
IFERROR(CHAR(BITXOR(CODE(chr), 32)) = chr, 0)
)
)and only to play with it, sure could be done other way. No more practical cases in my practice.
Even that is more than I had expected! I had definitely regarded BITXOR as lying within an exotic but very obscure corner of Excel. Perhaps not as bad as a Bessel function of the second kind, but close. Mind you, the finance formulas have their oddities; DOLLARFR means very little to me!
Presumably the trick in your formula is to move from lower case characters to upper case and the converse.