excel grouping
-
Group, count and order top words or phrases in Excel 2007
This is going to be one of those posts that's probably more for me than anyone else but recently it drove me a little loopy trying to sort out a basic task. I was asked to take one of excel error reports one of our websites generates and get a count for the top 20 recurring error messages. Sounds simple enough you might say, well thanks to Excel unless you know where to dig it can be a little frustrating to do!