Forum Discussion
Sort by merged cell size
Hey everyone, I am trying to sort data according to their merged cell size. This means I want to have a list with all the single cells first, then all the double merged cells, then triple merged cel...
This is going to sound perverse, but calculation (in this case a sort) is far easier if you avoid merging cells. The display can be made to look much the same by using conditional formatting to change the font colour to white, or the number format to blank, whenever successive cells contain the same ID.
By having the userID on every row, it is possible to count the occurrences rather than the size of the merged cell.
Note: SORTBY requires Excel 365.
Thank you so much. I will give it a shot and hope it will work! 🙂