How do you group a list of companies/account numbers that are duplicated on several rows (separate purchases) to identify companies that purchased specific products within 2 code ranges (c50-c509, c18-c20.) and include ALL of the that companies purchase rows regardless of the product code in that row, then sort the entire worksheet to place only those companies (and all their rows) who purchased those items within the specified code ranges on the top of the sheet to cut and paste onto a new excel sheet?
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!