I am trying to do a countif with a range that may change columns regularly. Basically I want the range to be the first cell in a particular column, down to another cell within the same column. I'm trying to leverage the Cell() function in my formula, but excel doesn't approve of that method and keeps sending back an error.
Example:
Countif(Cell("address",tbl1[Column1]):tbl1[@[Column1]],tbl1[@[Column1]]).
I am trying to replace this formula:
Countif($B$3:$B3,B3)
This counts duplicates in a moving range.
Does anyone know how to make the Cell() method work or another way to do what I am trying to do? Thanks!
Example:
Countif(Cell("address",tbl1[Column1]):tbl1[@[Column1]],tbl1[@[Column1]]).
I am trying to replace this formula:
Countif($B$3:$B3,B3)
This counts duplicates in a moving range.
Does anyone know how to make the Cell() method work or another way to do what I am trying to do? Thanks!