LAMBDA Examples: Distance between two cities

Chris_Gross Sameer_Bhide 

I had forgotten about this post but was led back here from Viz 's Fibonacci link above. Revisiting the methods described in previous comments I was pleased to find that it's now possible to define lambdas as addin functions that can be called from any open workbook.

Steps:
1. define lambdas in a new workbook
2. insert a macro sheet (ctrl+F11)
3. with the macro sheet selected, open name manager
4. edit name definitions clicking the Function option.
5. remove the macro sheet and save as addin (xlam).
6. open the addin and enter a test formula in a new workbook

Lambda definitions:
TIMEIT
=LET(t, timer(), LAMBDA(formula, timer() - t));
timer
=LAMBDA(ROUND(NOW()*24000*3600,0))

Test Formula:
=TIMEIT(SUM(SEQUENCE(1000,1000))) -> ¬60 milliseconds.