Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking between worksheets- then sorting data | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Sorting Data and Formula help... | Excel Discussion (Misc queries) | |||
data sorting problem | Excel Worksheet Functions | |||
Help in Sorting Data Please! | Excel Worksheet Functions |