Forum Discussion
Solved
How to display multiple items with the same value ranking
Hi, I've got a report that pulls in data from a cube source and I then sort it using a macro to rank all machines by percentage of availability for the time period. However some users of the report a...
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?
PeterBartholomew1 Perfect - this gave exactly the results I needed. Thanks so much for your help!