I have multiple rows with two types of information, type "A" and type "B" as noted in the first column. I am separating the types and organizing them on another sheet. My sorting uses the value of COUNTA(A:A)-1 (minus one for the header) to determine how far to go down the rows to separate by type and sort. However, this is dynamic and it is possible that entries get deleted (thus a blank entry in the column). Is there a way to get a count of the number of entries plus any blank entries in between, or determine the last row of data? My sort will allow for blank entries so that's not an issue. I just don't want to cut off the last row if there is a blank and my sort uses
For x=1 to (value of counta) and there is a blank in the middle of the data.
For x=1 to (value of counta) and there is a blank in the middle of the data.