I have a gentleman in my office that is wanting to set up his contact list in alphabetical order a few ways.

1. he wants to be able to search by last name
2. he wants to search by city/state

How do I write the formula to accomplish this?


Thanks for your help!
Jennifer