View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
noelle noelle is offline
external usenet poster
 
Posts: 2
Default Display a 1 for the first of duplicates

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.