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
|
|
|