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?
Here is an example in the inserted file.
Maybe it will help you further with your plans.
You just have to see if these formulas also work in Google Sheets.
As far as Google Sheets is concerned, my knowledge is limited.
- Thanks for that, I'm working in Excel but had to load it onto google drive so I could share it. I'll give that a go and see if it works for me
