Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 13:12:44 +0000



[Programming Help] - Spreadsheet Sorting of Numbers

View Count: 586

[2017-07-17 21:37:14]
User787778 - Posts: 139
I would like to rank a column of say 10 numbers, which are random in sequence, including duplicate numbers,into a different column, which is sequentially sorted and excludes any duplicates.
I could achieve most of this, by using =small(numbers,1) & =small(numbers,2) etc. except for the duplicate numbers.
Any assistance would be appreciated.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account