sort excluding multiple label rows [closed]
I want to sort a sheet by date in one of the columns. I know that there is a setting to exclude the first row which contains labels. However, since the sheet has many rows, I have inserted a row of the same labels as the first row at various intervals so that when I scroll down, I will still be able to see the labels for each column. The problem is that the presence of several label rows at a number of places interferes with the sort process since the several label rows (apart from the first row) are included in the sort. Is there a way to define a sort which would exclude any entries in the column which are text labels and not dates? I want the sort to take place without moving any of the various label rows which I have created.