Excel 2007 : Count Unique Values and

[Fishbubbles]

I am looking to create a formula that will look at values in column A, and at the first instance of a unique value, put an identifier (a 1 or an X) in column B next to it. I've attached a sample spreadsheet with an example of what I'm looking for.

[Ron Coderre]

Using your posted workbook, this regular formula flags the first instance of a Col_A value
B2: =IF(MATCH(A2,$A$1:$A$80,0)=ROW(A2),1,"")

Copy that formula down as far as you need.

Is that something you can work with?

[Fishbubbles]

That works like a charm. I haven't used Match before, but glad I know about it now. Thank you Ron!