Is there a particular reason you are asking to use OFFSET? I ask because
there are other ways to do this with out using a Volatile function like
OFFSET. Assuming your data starts in A2, put this in B2 and copy down...

=IF(A2="","",--(COUNTIF(A$2:A2,A2)=1))

and copy it down as far as you want.

--
Rick (MVP - Excel)


"myk" wrote in message
...
Hello,

I have a list of names in column A (a4:a14). In column B I would like
to indicate if the name in column A is a duplicate. Column A is
sorted. Below is the example - I would like to put my OFFSET function
in the DUPLICATE INDICATOR column and use a 1 to indicate the first
occurnace of a name and a 0 for indicating a duplicate.

NAME DUPLICATE INDICATOR
Jack
Jack
Jack
Jill
Fred
Fred
Fred
Fred
Mark
Nancy
Nancy

Thank you!!

myk