Hi
then just change the range reference. e.g. change
A1:A20 (all occurences) to
A1:A100 (or whatever is required)

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
Thanks Frank ... however that didnt work for me here ... some of my
sheets also contain more than 20 rows :(



"Frank Kabel" wrote:

Hi
try:
=SUMPRODUCT((A1:A20<"")/(COUNTIF(A1:A20,A1:A20)+(A1:A20= "")))

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
Hello All

Yet another problem ... have spreadsheed with multiple rows of
data,
however I am looking to find a way of counting unique entries ...

ie data in colums such as ... 123 234 345 456 123 345 789

I am looking for a count function to tell me that there are 5
different indivdual values within this set ... not lookking for
number of entries just identifying the different unique individual
entries

Many Thanks

Alan