Hi all,
I have a profit and loss report that includes a Category column and a Sub Category column.
I filled down the Category column with great success. However, there only exists a handful of Sub Categories in a data set with hundreds of rows.
See pics below. The Sub Categories normally have a cell with the text that describes the Sub Category and then a couple of blanks rows, then the same Sub Category written with the addition of the word "Total". (See pics)
How do I Fill Down between these 2 values as a typical Fill Down will also repeat the "Total...." Sub Cat as well which isn't correct.
Any ideas??
I have a profit and loss report that includes a Category column and a Sub Category column.
I filled down the Category column with great success. However, there only exists a handful of Sub Categories in a data set with hundreds of rows.
See pics below. The Sub Categories normally have a cell with the text that describes the Sub Category and then a couple of blanks rows, then the same Sub Category written with the addition of the word "Total". (See pics)
How do I Fill Down between these 2 values as a typical Fill Down will also repeat the "Total...." Sub Cat as well which isn't correct.
Any ideas??