I have this formula, =COUNTIF($E$2:$E$250,J2), which I want to modify
so that the range 250 will be dynamic like get the return of
=COUNTA(E:E). What is the best way to go about it?

Thanks.