Support Board

Date/Time: Sun, 19 May 2024 15:32:51 +0000

Post From: Spreadsheet Sorting of Numbers

[2017-07-17 21:37:14] Link To Thread - Link To Post [Go To First Post]
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.