I am looking for a way to count the last 10 items that are greather than and less than in a particular set of cells.
I am using the following formula for the less than and greather count.
:D22)) = formula in cell C2
:D22)) = formula in cell D2
This gets the job done with some issues.
First, I have to manually change the cell ranges to match after data is added.
Second, any blanks in between may be omitted so that I do not get the full 10 count range I want.
Does anyone know of a way to do this without manually changing the cell ranges each time data is added.
P.S. I tried using INDIRECT("C" & B2) to use the value in cell B2 as the last cell number but I get an error when inserted in place of the static cell range used in the formula.