Excel Function in UDF

[alex_k]

Hello,

I use a following function to count the string occurence, at it first
appearance in a range:

=IF(COUNTIF(A$1:A1,A1)>1,"",COUNTIF(A$1:A$7,A1))

I want to make an UDF from this function, where I could select the the
fixed range <A$1,A$7>, and copy the function into the column B to get the
count.

Example: Column A contains the string array, Column B contains the count

----------------------------------
Row
Column A B
----------------------------------
1 1 2
2 1
3 3 2
4 4 1
5 7 2
6 7
7 3