Dear Yudha formula if dan countif bisa digunakan. =IF(COUNTIFS($A$4:$A$16,A4,$B$4:$B$16,B4,$D$4:$D$16,D4)>1,"GANDA","") lebih jelasnya lihat file terlampir
________________________________ Dari: yudha pramudji <[email protected]> Kepada: "[email protected]" <[email protected]> Dikirim: Jumat, 12 April 2013 15:49 Judul: [belajar-excel] Re: Mencari data ganda maaf terlupa attach filenya
AA - contoh.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
