count data in column and identify first

[it's an excel world]

Hello all,

I have a worksheet with several columns of data. In column B I have records that are unique to particular orders. However, these unique values can be listed more than once in column B. I was looking for a formula that would search down column B and in column A woud return a "1" if the value in column B is only found once. However, if the value is found mulitple times, I would like "1" indicated for the first row that has the value and "0" in the subsequent rows.

Thanks in advance!!

 

[mikerickson]

Try this in A1 dragged down

=IF(ROW(B1)=MATCH(B1,B:B,0), 1, 0)
or
=--(ROW(B1)=MATCH(B1,B:B,0)