Count only one order number in a list of values

[david1987]

Hi,

I have a list of order numbers in Column A. If there are duplicate order numbers I only want to assign a 1 value against one of the values in column B.

I've attached how I want column B to look when it has a formula in it.

Many Thanks

David

[XOR LX]

Hi,

Try this in B2 and copy down:

=IF(ROWS($2:2)=MATCH(A2,$A$2:$A$13,0),1,0)

Regards

[Pete_UK]

Put this in B2:

=--(COUNTIF(A$2:A2,A2)=1)

then copy down.

Hope this helps.

Pete

[oeldere]

with if (count if)

See the attached file.