Instances - Duplicates

[dforte]

I received help with a formula to determine the following:

If in column a there are a list of names, of which many are duplicated, column B will create a numeric output of either 1 or 0. 1 being the first instance of a name and 0 being every instance thereafter. The formula looked like this:

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

This works well. However, I have several lists of names still within the same columns and on the same sheet, but divided into different sections by headings.

The above formula works well in calculating the first time a name appears in each individual list, but I would like a formula for a single cell at the end of several sections of names to tell me the same thing while accounting for the possibility of duplicates between sections as well.

I realize I could run this same formula down the side of the sheet, but it would be nice to have a neat formula for a single cell. Any suggestions?

[martindwilson]

maybe =IF(COUNTIF($A$1:$A1,A1)=COUNTIF($a:$a,A1),1,0) other than that post a sample workbook

[dforte]

I think I've decided to use that same formula I had initially and cut and paste it from section to section.. that seems to work well. Thanks anyway!