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?
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?
"any calculation that might be performed in any other computer language (eg VBA macros) can be performed using Excel's formula language"
Are you sure? What about cell properties and staff like time stamp?
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.
PeterBartholomew1 Perfect - this gave exactly the results I needed. Thanks so much for your help!
