Delete repeated values

Question

I have a long list of invoices. The invoice numbers (BEL_NR column) are repeated as each one of them contain at least one position, that means that data referring to logistics costs for each invoice is also repeated in column Frachtkosten. What I'm trying to do is to delete consecutive repeated values, leaving only the first one.

For example: put 0 in C3 because A2 in repeated in A3.

I attach a picture of what I intend to do: on the left is what I have, on the right is what I'd like to have. Please note I can't do that manually as the list is so so long.

Answer 1

In Row2 of a spare column enter and copy down:

=A2=A1  

Filter that column to select FALSE, enter 0 in the first displayed cell (excluding header) for Frachtkosten and copy down.