I have an issue where excel sticks in the background. Using Procmon I can see that the last thing it does is attempt to open a registry key: HKCU\Software\Microsoft\Office\16.0\Outlook\Ripcord The key does not exist. Anyone know what excel is doing here? ...
Hi all - doing some exploring with lets and lambda in excel and passing arrays around. I found a weird quirk where something that should work doesn't work as expected in a surprising way. This problem also (or primarily) appears with byrow. This formula results in the fo...
I am not really sophisticated enough to implement the various timing functions I've seen, so I don't know how to answer the question, but do byrow/bycolumn have meaningful efficiencies over mapping a one by X row/column? Maybe if I just use MAP I'll solve my problems, but if i...
Hi all - doing some exploring with lets and lambda in excel and passing arrays around. I found a weird quirk where something that should work doesn't work as expected in a surprising way. This prob... joelb95 Second one =LET(many,LAMBDA(choice,CHOOSE(choice+1,10,"b","harry...
Hi all - doing some exploring with lets and lambda in excel and passing arrays around. I found a weird quirk where something that should work doesn't work as expected in a surprising way. This prob... joelb95 BYCOL. Not sure what you'd like to receive. In general we have...