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...

Formulas and Functions

PeterBartholomew1
Feb 25, 2024
Kevin_Adams85
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

Silver Contributor

Feb 25, 2024

Kevin_Adams85

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