|  | Special Sorting Need Advice... | | |
| | | KCPDX |  |
|  Posted: Tue Aug 12, 2008 9:12 am Post subject: Special Sorting Need Advice... |  |
I need help sorting a row a certain alphanumeric way.
Currently i have this..
2b
1
1a
3b
2
1b
2a
3
3a
and i need it to look like this
1a
1b
2a
2b
3a
3b
1
2
3
Is there a special sort to do this, any help would be great!
Thanks
Kris |
| |
| | | Bob Phillips | |
| | Posted: Tue Aug 12, 2008 9:12 am Post subject: Re: Special Sorting Need Advice... | |
I would suggest that you use some helper cells to extract the number and
alpha separately and sort on these.
Is it always 1 digit 1 alpha, or is it more complex?
--
__________________________________
HTH
Bob
"KCPDX" <kris.crispell@gmail.com> wrote in message
news:00390cf4-d537-4a30-92ea-516f91961c9b@s1g2000pra.googlegroups.com...
| Quote: | I need help sorting a row a certain alphanumeric way.
Currently i have this..
2b
1
1a
3b
2
1b
2a
3
3a
and i need it to look like this
1a
1b
2a
2b
3a
3b
1
2
3
Is there a special sort to do this, any help would be great!
Thanks
Kris |
|
| |
| | | KCPDX | |
| | Posted: Tue Aug 12, 2008 3:47 pm Post subject: Re: Special Sorting Need Advice... | |
Its just as simple as that, there might a situation where the a
numeric aphla might go beyond 10
7a
8a
9a
10a
11a
12a
ect
On Aug 12, 2:25 am, "Bob Phillips" <Bob...@somewhere.com> wrote:
| Quote: | I would suggest that you use some helper cells to extract the number and
alpha separately and sort on these.
Is it always 1 digit 1 alpha, or is it more complex?
--
__________________________________
HTH
Bob
"KCPDX" <kris.crisp...@gmail.com> wrote in message
news:00390cf4-d537-4a30-92ea-516f91961c9b@s1g2000pra.googlegroups.com...
I need help sorting a row a certain alphanumeric way.
Currently i have this..
2b
1
1a
3b
2
1b
2a
3
3a
and i need it to look like this
1a
1b
2a
2b
3a
3b
1
2
3
Is there a special sort to do this, any help would be great!
Thanks
Kris |
|
| |
| | | Pete_UK | |
| | Posted: Tue Aug 12, 2008 3:54 pm Post subject: Re: Special Sorting Need Advice... | |
| |  | |
To get the number only into a helper cell you can use:
=LEFT(A1,LEN(A1)-1)*1
and to get the alpha character you can use:
=RIGHT(A1,1)
in another column. Then copy these down as required. When sorting,
include these helper columns within the range to be sorted, click on
Data | Sort, and sort on the number first followed by the alpha
character.
Hope this helps.
Pete
On Aug 12, 4:47 pm, KCPDX <kris.crisp...@gmail.com> wrote:
| Quote: | Its just as simple as that, there might a situation where the a
numeric aphla might go beyond 10
7a
8a
9a
10a
11a
12a
ect
On Aug 12, 2:25 am, "Bob Phillips" <Bob...@somewhere.com> wrote:
I would suggest that you use some helper cells to extract the number and
alpha separately and sort on these.
Is it always 1 digit 1 alpha, or is it more complex?
--
__________________________________
HTH
Bob
"KCPDX" <kris.crisp...@gmail.com> wrote in message
news:00390cf4-d537-4a30-92ea-516f91961c9b@s1g2000pra.googlegroups.com...
I need help sorting a row a certain alphanumeric way.
Currently i have this..
2b
1
1a
3b
2
1b
2a
3
3a
and i need it to look like this
1a
1b
2a
2b
3a
3b
1
2
3
Is there a special sort to do this, any help would be great!
Thanks
Kris- Hide quoted text -
- Show quoted text - |
|
| |
|
|
