Are the addresses in the same cell as the names or different? If the addresses are in their own cells in a separate column you should be able to just select all of them and then assort either ascending or descending and get them in alphabetical order. Then the same addresses would be together.
Let me know if I am missing anything. I am an average Excel user so odds are when you come back somebody a little more handy will be here. I also am not on my computer with Excel so I am just going off the memory of what options there are. Also a little confused on if you are asking for more than I think you are.
|