Sorting problem

Hi,

I have a document that I update on a regular basis and I need to sort it by 3 columns.

Column A has the name of the client, Column B has the House number and column C has the quotes:

Bellow is an example of column C.
1 of 12
2 of 12
3 of 12
4 of 12
5 of 12
6 of 12
7 of 12
8 of 12
9 of 12
10 of 12
11 of 12
12 of 12


My problem is that when I insert new clients I like to sort them. I use the sort comand and have it sorted by Client name, then by house number and finnally by quote. When I do this, I get the following in column C.

1 of 12
10 of 12
11 of 12
12 of 12
2 of 12
3 of 12
4 of 12
5 of 12
6 of 12
7 of 12
8 of 12
9 of 12

Any way I can solve this sorting problem?
I like the "1 of 12" format because I can select an drag down to the next cell and it populates automatically to "2 of 12", "3 of 12" and so on.

Thanks!

YOU NEED TO DEFINE 1 2 3 4 5 6 7 8 9 10 11 12 as text in a custom sort order as clearly your data is text, then sort as you do but chose your own custom sort

it is explained in excel help

Originally Posted by robert111

YOU NEED TO DEFINE 1 2 3 4 5 6 7 8 9 10 11 12 as text in a custom sort order as clearly your data is text, then sort as you do but chose your own custom sort

it is explained in excel help

Hi,
Thanks for the tip, it works partially.

This solution works if I´m sorting based on one column alone (column C), but when I´m sorting using the 3 paramenters in the "ColumnA","ColumnB","ColumnC" order it doesn´t. (????)

Excel bug?

It sounds like you just want column C to reference a number count for the amount of clients you have. Instead of sorting column C you could populate it with a formula; assuming row 1 has headers.

Please Login or Register  to view this content.