vebeenator
New Member
- Joined
- Apr 1, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hi thread members
As i am learning the traits of excel, i have stumbled up on a problem.
I have the numbers i want to work with organised in cell (d5:d56), i now want to select 26 of these numbers randomly
and organise them in ascending order in a row with no possibility of retrieving duplicates, furthermore i want to retrieve the remaining 26 numbers from (d5:d56) and organise them
in another row.
Any help will be highly appreciated.
As i am learning the traits of excel, i have stumbled up on a problem.
I have the numbers i want to work with organised in cell (d5:d56), i now want to select 26 of these numbers randomly
and organise them in ascending order in a row with no possibility of retrieving duplicates, furthermore i want to retrieve the remaining 26 numbers from (d5:d56) and organise them
in another row.
Any help will be highly appreciated.