BenjaminLucas
New Member
Hi everyone,
As part of a project, I'm looking to find the average from a data set on another sheet, but only between specific rows. The rows on the data set are already laid out in two columns (highlighted below). This wouldn't normally be a problem, but I have to do it for 100s of rows.
I was hoping to see if there is anyway I can automate this process so I am not having to manually type in the range that I want to cover, as I have been doing so far. (I have been deleting the numerical value in front of the 'C' and replacing it with the values that correspond to each row).
Any help would be really appreciated!!
As part of a project, I'm looking to find the average from a data set on another sheet, but only between specific rows. The rows on the data set are already laid out in two columns (highlighted below). This wouldn't normally be a problem, but I have to do it for 100s of rows.
I was hoping to see if there is anyway I can automate this process so I am not having to manually type in the range that I want to cover, as I have been doing so far. (I have been deleting the numerical value in front of the 'C' and replacing it with the values that correspond to each row).
Any help would be really appreciated!!