Hi,
I have a lot of data which I have summarised in table using sumifs based on a few variables. When these items are selected the table updates itself. What I would like to do is have the rows sort automatically so that there are not gaps in the data. I have attached a very simple example.
I.e. when I update the month in M5 it changes the table L8:M8 as you can see there are zero cells, I only want to show the relevant data.
Without using a filter is it possible for the calculation to sort the rows?
Any help would be appreciated.
Thank you
I have a lot of data which I have summarised in table using sumifs based on a few variables. When these items are selected the table updates itself. What I would like to do is have the rows sort automatically so that there are not gaps in the data. I have attached a very simple example.
I.e. when I update the month in M5 it changes the table L8:M8 as you can see there are zero cells, I only want to show the relevant data.
Without using a filter is it possible for the calculation to sort the rows?
Any help would be appreciated.
Thank you
