SOLVED

massive sort in Excel

Copper Contributor

Hello.
I have a problem with sorting. I need to sort approximately 8 thousand strings of numbers line by line. That is, it is necessary that in each line the numbers are arranged in ascending order. How to do it?

3 Replies
best response confirmed by tensashi (Copper Contributor)
Solution

@tensashi If you have a modern Excel version you can try this:

Riny_van_Eekelen_0-1708347103906.png

 

@Riny_van_Eekelen, thanks for trying to help me.
Unfortunately, your solution doesn't fit.
The numbers are in rows in each cell, as in the screenshot. and the result is also needed in this format. It is possible to rearrange the numbers in the cells in which they appear. 

Снимок экрана 2024-02-19 164714.png

I found solution. Thx for help :)
1 best response

Accepted Solutions
best response confirmed by tensashi (Copper Contributor)
Solution

@tensashi If you have a modern Excel version you can try this:

Riny_van_Eekelen_0-1708347103906.png

 

View solution in original post