I have been working on a problem in a sheet I have been building to track grants and projects for my program. In this sheet, data is sorted by grant IDs and their associated projects. Grants are grouped by their associated projects using the grouping function. My problem is that there seems to be an error when I attempt to sort rows, and Excel is behaving unpredictably.

This image shows the data as I have input it. For example, if I sort by “Funding Amount” largest to smallest, this is the result:

I’m not really sure to make of what Excel is doing here… or if there is a fix for this. Some of my other workbooks use similar organizational patterns so I’m unsure why this one doesn’t work. I have attempted to use custom sorting, and I’ve followed a few other sets of instructions on here to no avail. I would be open to consolidating some of these columns but some will have to stay separated for sorting purposes. Thanks in advance!

​I have been working on a problem in a sheet I have been building to track grants and projects for my program. In this sheet, data is sorted by grant IDs and their associated projects. Grants are grouped by their associated projects using the grouping function. My problem is that there seems to be an error when I attempt to sort rows, and Excel is behaving unpredictably.This image shows the data as I have input it. For example, if I sort by “Funding Amount” largest to smallest, this is the result:I’m not really sure to make of what Excel is doing here… or if there is a fix for this. Some of my other workbooks use similar organizational patterns so I’m unsure why this one doesn’t work. I have attempted to use custom sorting, and I’ve followed a few other sets of instructions on here to no avail. I would be open to consolidating some of these columns but some will have to stay separated for sorting purposes. Thanks in advance!  Read More

​