Forum Discussion
How to display multiple items with the same value ranking
It is claimed that Excel 365 is Turing complete; that is any calculation that might be performed in any other computer language (eg VBA macros) can be performed using Excel's formula language.
Here, I called the data table taken from cube 'Source'.
In which case the output table is given by
= SORT(Source, 2)The greatest obstacle to using 365 effectively can be the user's existing knowledge of spreadsheet techniques?
The main things I used VBA for were event handlers and adjusting the properties of shapes so that diagrams adjust to conform to underlying data sets. I certainly can't do that with an Excel formula but then, I am not sure it falls within the scope of Alan Turing's envisaged computational machine either.
I'm not familiar with Turing machine concept, my guess that's just the model of computation. Which allows iterations, recursion, etc. If we don't use it in working with properties that doesn't mean machine itself is not applicable in such case.