If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting data
Hi
Is it possible to group data together so that it stays together when I sort it alphabetically? I'd like to make a list for example, Police, Fire and Ambulance stations. In cell a1 would be Police followed in b1, b2, b3, etc the names of the stations. Then in c1,c2,c3 etc the relevant telephone numbers. Then in a 4 would be Fire, followed by b4, b5, b6 etc the names of the fire stations and then their tel numbers in c4, c5, c6 etc.The same applies to Ambulance. Then I'd like to sort col A and keep col b and col c together under the proper emergency service Hope you can understand what I mean TIA Steve |
#2
|
|||
|
|||
Steve
If I understand, you can only realistically do this by putting Police in A2, A3, etc. That is list the service multiple times. That way you can then sort on service and then station -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Steve" swr1953(at)yahoo(dot)co(dot)uk wrote in message ... Hi Is it possible to group data together so that it stays together when I sort it alphabetically? I'd like to make a list for example, Police, Fire and Ambulance stations. In cell a1 would be Police followed in b1, b2, b3, etc the names of the stations. Then in c1,c2,c3 etc the relevant telephone numbers. Then in a 4 would be Fire, followed by b4, b5, b6 etc the names of the fire stations and then their tel numbers in c4, c5, c6 etc.The same applies to Ambulance. Then I'd like to sort col A and keep col b and col c together under the proper emergency service Hope you can understand what I mean TIA Steve |
#3
|
|||
|
|||
Excel doesn't (to my knowledge) allow you to set up a number of sort
templates so that you can easily sort data in a number of ways. You have to set it up every time. One way around this is to set up a data field to concatenate the data in the required order (SORT1 may be =A1&B1&C1 and SORT2 may be B1&A1&C1). You then have to sort on only one field to effectively sort on a number of fields. This is also useful if you need to sort on more than the three fields allowed. In this form it is only a sort on a 'string'. You may have to include something like 'value(An)' to sort by value. Unfortunately you cannot sort by descending order. Regards. Bill Ridgeway Computer Solutions "Nick Hodge" wrote in message ... Steve If I understand, you can only realistically do this by putting Police in A2, A3, etc. That is list the service multiple times. That way you can then sort on service and then station -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Steve" swr1953(at)yahoo(dot)co(dot)uk wrote in message ... Hi Is it possible to group data together so that it stays together when I sort it alphabetically? I'd like to make a list for example, Police, Fire and Ambulance stations. In cell a1 would be Police followed in b1, b2, b3, etc the names of the stations. Then in c1,c2,c3 etc the relevant telephone numbers. Then in a 4 would be Fire, followed by b4, b5, b6 etc the names of the fire stations and then their tel numbers in c4, c5, c6 etc.The same applies to Ambulance. Then I'd like to sort col A and keep col b and col c together under the proper emergency service Hope you can understand what I mean TIA Steve |
#4
|
|||
|
|||
If you need to print the result, add another column in between and insert if(a2=a1,"",a2) Use A only to sort, and B and C to print i format as you desire. HTH | Steve | | If I understand, you can only realistically do this by putting Police in A2, | A3, etc. That is list the service multiple times. That way you can then | sort on service and then station | | -- | HTH | Nick Hodge | Microsoft MVP - Excel | Southampton, England |
#5
|
|||
|
|||
Ooops,
Sort using A as the initial sort criteria, along with other columns that are required (eg C and D) leave B containing the formula out of the sort | If you need to print the result, | add another column in between and insert if(a2=a1,"",a2) | | Use A only to sort, and B and C to print i format as you desire. | | HTH | | | | | Steve | | | | If I understand, you can only realistically do this by putting Police in A2, | | A3, etc. That is list the service multiple times. That way you can then | | sort on service and then station | | | | -- | | HTH | | Nick Hodge | | Microsoft MVP - Excel | | Southampton, England | | | |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
data sorting and parsing | Param Dhillon | General Discussion | 0 | February 23rd, 2005 11:13 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |