Hello,

I'm not sure how to do this. I have attached my excel spreadsheet. In the spreadsheet are column titles for categorizing books by title, author, illustrator, publisher company, isbn, etc. I have over 400 records in this spreadsheet. What I want to do is sort the 400+ records by the publisher that comes up the most in the spreadsheet to the publisher that comes up the least in the spreadsheet. So for example, in the first row of the spreadsheet, the publisher for Mickey's Spooky Night Read along book is from "Disney Book Group". If "Disney Book Group" has more than one record result in the 400+ records, I want it along with it's rows of Disney Book Group to be prioritized and placed at the top of the stack.

If you look at row 8, you will see, It's a Great Pumpkin Charlie Brown, with a publisher titled "Peanuts Worldwide". In this sorting algorithm, if this record is the only one within the 400+ records that shows up only once for Peanuts Worldwide, I want this record to be last and at the bottom of the stack.


So can someone explain to me what I have to do in order to make this all work? An excel spreadsheet example would be nice.

Thanks,

Michael

Attached Files

Barnes and Noble Nook Kids.xls (93.0 KB, 13 views)