troubleshooting Question

How do I sort an excel spread of random Hash values in one and I want to most frequently matcing set first

Avatar of Christopher Schene
Christopher ScheneFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
7 Comments1 Solution183 ViewsLast Modified:
here is my table
name, hash, phone
chris, random hasha, phone chris
george, random hashn, phone george
kyle, random hasha, phone kyle
sally, random hashn, phone sally
kathy, random hasha, phone kathy

After the table is sorted I want it sorted by the has id's with most frequently occurring at the top and by decending count
chris, random hasha, phone chris
kyle, random hasha, phone kyle
kathy, random hasha, phone kathy
george, random hashn, phone george
sally, random hashn, phone sally

Excel only gives me the option to sort numerically or alphanumerically, I want to sort by match and I want the items that match the most in descending order at the top of the list
ASKER CERTIFIED SOLUTION
Gary Kline
President, Kline Info Systems, Inc.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros