=SUMPRODUCT((A8:INDEX(A8:A1000,COUNTA(A:A))<"")/COUNTIF(A8:INDEX(A8:A1000,COUNTA(A:A)),A8:INDEX(A8 :A1000,COUNTA(A:A))&""))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leon" wrote in message
...
I have the following formula:
=SUMPRODUCT((A8:A100<"")/COUNTIF(A8:A100,A8:A100&""))

This formula counts the number of unique records in a column (A)

The column (A) grows every day to a variable amount I need to replace the
(100) by the value of a cell that counts the row in column (A)

I tried all the variations of "INDIRECT) but it doesn't seem to work.
Obviously my syntax is not right.

Any pointer will be gratefully appreciated.

Thanks in advance