Wa'alaykum salam warohmatullohi wabarokatuhu.. coba pada kolom bantu format text nya ditambahin [$-21] sebelum MMMM.
ganti formula pada kolom bantu: =IF(CONCATENATE(TEXT(B3,"MMMM"),E3)<>CONCATENATE(TEXT(B4,"MMMM"),E4),CONCATENATE(TEXT(B3,"MMMM"),E3),"") menjadi: =IF(CONCATENATE(TEXT(B3,"[$-21]MMMM"),E3)<>CONCATENATE(TEXT(B4,"[$-21]MMMM"),E4),CONCATENATE(TEXT(B3,"[$-21]MMMM"),E3),"") lalu copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: Mulyani To: [email protected] Sent: Thursday, March 27, 2014 8:30 AM Subject: Re: [belajar-excel] HARGA TERBARU Assalaamu'alaikum Pa Bagus & Pa Heri terima kasih solusinya ya, tapi file yang dari Pa Heri ko nilainya ga keluar ya Pa?
