Results 1 to 2 of 2

Thread: Grouping cells together break sorting

  1. #1

    Grouping cells together break sorting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I'm working on this spreadsheet right now which lists my music CDs collection;
    For each album, notice I've grouped cells together to list all the songs of the album - The rating (column O) of the album "The Three Words to Remember in Dealing with the End" is 95%, which is calculated with the average of every song of the album. This works:
    =AVERAGE(O18:O21)

    Click image for larger version. 

Name:	ExcelCDs.jpg 
Views:	11 
Size:	100.1 KB 
ID:	3162

    The only concern with grouping cells together, is when I want to sort the albums rating, from smallest ratings to highest. Obviously trying to sort them makes the result incorrect. The album "The Three Words to Remember in Dealing with the End" should be the highest rated at 95%.

    Click image for larger version. 

Name:	ExcelSorting.jpg 
Views:	5 
Size:	101.6 KB 
ID:	3163

    Obviously the songs listed under "The Three Words to Remember in Dealing with the End" are also incorrect - these songs are from a totally different album.

    I understand that the formula =AVERAGE(O18:O21) is intended for specific cells, and so when you sort the Rating column, these cells changes, so it break normal sorting. I wonder how I should reorganize/restart my document to acheive what I would want to do. Any advice?

    Thank you, I appreciate it.

  2. #2
    Fixed;
    I just put the songs in a new sheet of his own. That way when I've sorted the albums by ratings, it still work.
    Was actually simple.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •