special sort on telephone numbers

[Yaseraliakram]

hi guys i have a table below.
In example a if i do the simple sort function i get result A, But i need to get to result B can anyone help me with this ?



Result A Result B

Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile
Algeria Mobile		Algeria Mobile

<colgroup><col style="mso-width-source:userset;mso-width-alt:3140;width:69pt" width="92"> <col style="width:51pt" width="68" span="2"> <col style="mso-width-source:userset;mso-width-alt:3140;width:69pt" width="92"> <col style="width:51pt" width="68"> </colgroup><tbody>
[TD="width: 92"]Algeria Mobile[/TD]
[TD="width: 68, align: right"]2135[/TD]
[TD="width: 68"][/TD]
[TD="width: 92"]Algeria Mobile[/TD]
[TD="width: 68, align: right"]2135[/TD]

[TD="align: right"]2136[/TD]

[TD="align: right"]21355[/TD]

[TD="align: right"]21355[/TD]

[TD="align: right"]21356[/TD]

[TD="align: right"]21356[/TD]

[TD="align: right"]213560[/TD]

[TD="align: right"]21365[/TD]

[TD="align: right"]213561[/TD]

[TD="align: right"]21366[/TD]

[TD="align: right"]2136[/TD]

[TD="align: right"]21367[/TD]

[TD="align: right"]21365[/TD]

[TD="align: right"]21368[/TD]

[TD="align: right"]213659[/TD]

[TD="align: right"]21369[/TD]

[TD="align: right"]21366[/TD]

[TD="align: right"]213560[/TD]

[TD="align: right"]21367[/TD]

[TD="align: right"]213561[/TD]

[TD="align: right"]213670[/TD]

[TD="align: right"]213659[/TD]

[TD="align: right"]21368[/TD]

[TD="align: right"]213670[/TD]

[TD="align: right"]21369[/TD]

</tbody>

 

[Giordano Bruno]

It appears to be sorting based on values. If you make another column with a formula like = text(value('phone number reference cell',"general")) and sort on that you should get what you want

 

[Yaseraliakram]

thnx working perfeclty

 

[Peter_SSs]

See if this does what you want. Add the following formula to a third column & copy down.

Excel 2016
	A	B	C
2	Algeria Mobile	2135	Algeria Mobile2135
3	Algeria Mobile	2136	Algeria Mobile2136
4	Algeria Mobile	21355	Algeria Mobile21355
5	Algeria Mobile	21356	Algeria Mobile21356
6	Algeria Mobile	21365	Algeria Mobile21365
7	Algeria Mobile	21366	Algeria Mobile21366
8	Algeria Mobile	21367	Algeria Mobile21367
9	Algeria Mobile	21368	Algeria Mobile21368
10	Algeria Mobile	21369	Algeria Mobile21369
11	Algeria Mobile	213560	Algeria Mobile213560
12	Algeria Mobile	213561	Algeria Mobile213561
13	Algeria Mobile	213659	Algeria Mobile213659
14	Algeria Mobile	213670	Algeria Mobile213670
Sort

Cell Formulas
Range	Formula
C2	=A2&B2

Then select all 3 columns and sort on the new formula column. The result as follows and you can delete the extra column if desired

Excel 2016
	A	B	C
2	Algeria Mobile	2135	Algeria Mobile2135
3	Algeria Mobile	21355	Algeria Mobile21355
4	Algeria Mobile	21356	Algeria Mobile21356
5	Algeria Mobile	213560	Algeria Mobile213560
6	Algeria Mobile	213561	Algeria Mobile213561
7	Algeria Mobile	2136	Algeria Mobile2136
8	Algeria Mobile	21365	Algeria Mobile21365
9	Algeria Mobile	213659	Algeria Mobile213659
10	Algeria Mobile	21366	Algeria Mobile21366
11	Algeria Mobile	21367	Algeria Mobile21367
12	Algeria Mobile	213670	Algeria Mobile213670
13	Algeria Mobile	21368	Algeria Mobile21368
14	Algeria Mobile	21369	Algeria Mobile21369
Sort

 

[Peter_SSs]

thnx working perfeclty

Sorry, I missed that reply. Does that mean that all your column A values are the same or that the column A value does not come into the sort at all?