How to Lock cell Formula references when Using Data Tables

[zuriqi]

Hi

I have a table, in col A (header name is ColA), there are items from A2 to A100. Col B (header name is ColB) will get the number of reparation of cell value in Col A using this formula in B2=COUNTIF($A$2:A2,A2). The question is. Can i modify this formula after converting the range to structure table and use a formula to consider the header name instead A ?

in short: How to Lock this cell Formula references when Using Data Tables using the header names not A.

Thanks

 

[Tetra201]

Here is an equivalent of =COUNTIF($A$1:A2,A2)

=COUNTIF(Table1[[#Headers],[ColA]:[ColA]]:[@ColA],[@ColA])