SOLVED

Number Sorting is not working

Contributor

Hello All,

 

In the attached sheet , I am not able to sort Column B from low to hight in 5026ADDLoad(sorting)tab. It used to work.

 

Thanks,

Sam

5 Replies
best response confirmed by SamFares (Contributor)
Solution

@SamFares You have used the MID function. That makes everything text. And your column B is sorted as text.

Use this in stead:

=VALUE(MID([@Mark],2,3))

 

Thank you @Riny_van_Eekelen !

 

@Riny_van_Eekelen What i am not sure about how it worked in a different sheet( attached) without using "VALUE"

@SamFares Which column is your formula in?

@Riny_van_Eekelen  "D=26-48, L=50ft(WN Joists)"  column B . i did it few weeks ago. 

@SamFares 

Most probably it was set this option on sorting

image.png

More about sorting Sort data in a range or table - Excel (microsoft.com)