Re: [belajar-excel] Data yang sekali muncul

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

coba pake formula:
If(countif(range yg ada,target yg di tuju)>1,"",target yg di tuju)

misal:

Di tempatkan di column B

=IF(Countif($A$2:$A$10,A2)>1," ",A2)

TerimaKasih.

Sent from Yahoo Mail on Android