Display a 1 for the first of duplicates
Great, thanks. That worked!
Would you mind explaining the components so I understand how it works? It's
really been bugging me that I can't figure this out!
Thanks again.
"Stefi" wrote:
Try this formula:
=--(MATCH(A2,A:A,0)=ROW(A2))
and drag it down as required!
Regards,
Stefi
€˛noelle€¯ ezt Ć*rta:
I have a list of records that have many duplicates. I need a formula that I
can use in the adjacent column to show a 1 for the first instance of a
duplicate and a 0 for any others. The list is sorted so all dupes are
together.
|