I have a table (A6:AA2026) where column contains 14 different names. I want to hide column A but have it sort based on the contents of cell K1 (a data validation cell containing a list of the the 14 names in column A). How can I do this?
Software/Hardware used: Excel 2010
Ask a Question
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!