I would like a formula that will give me the unique list of items in Col A but will give them to me in alphabetical order. Sample list of data and desired result below.
List of Items Desired Result
Lamp Chair
Table Desk
Chair Filing Cabinet
Filing Cabinet Lamp
Lamp Phone
Desk Table
Phone
Chair
Thanks for the help.
Bookmarks