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