SORTING

[David Harrison]

Please Help

I think this is quite easy for most but for some strange
reason i cant get my head around it.

I have a range of cells in a collumn that are sorted.

first all the 1's then the 2's etc etc.

The problem i am having is how do i Incorporate so that
after 4 will come the 5A's and then the 5B's.

Another problem i am having is how do i use a count if
funtion. i want to count the number of 5A's and 5B's but
the function comes up incorrect because it wants to read
5A and 5B as cells.

Regards
David

 

[Peo Sjoblom]

You would need a help column that extracts the numbers, then sort by this
column,

=IF(ISTEXT(A2),--LEFT(A2,LEN(A2)-1),A2)

copied down

the above works if those cells with letters as well only have one letter, if
not
it becomes a bit more complicated, this formula assumes that the value
starts with a number

=--LEFT(A2,MATCH(FALSE,ISNUMBER(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2)))+1,1)),0
))

entered with ctrl + shift & enter