Tanya rumus isi tgl otomatis

[Agus Ramiyanto]

Dear Pakar Excel,

Mohon bantuannya u membuat rumus agar muncul tgl otomatis dari data tabel yang di atasnya di file terlampir.

Demikian yang dapat kami sampaikan.

 

Thanks & Regards,

Agus Ramiyanto

[Mr. Kid]

Asumsi : tidak ada nomor peserta yang duplicate

=INDEX($B$11:$B$15,SUMPRODUCT(($C$11:$F$15=$B21)*ROW($C$11:$F$15))-ROW($C$10))

manfaatkan iferror diluar index jika ada data yang menghasilkan error value

Regards,

Kid

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGnuTnwH5Tz_%3DdHiQBzigG-Kbg-OVuTX4gDRCjTRh5DHaw9Q3A%40mail.gmail.com.

[Mr. Kid]

Jika boleh pakai format cells, bisa begini :

=MAX($B$11:$B$15^($C$11:$F$15=$B21))

kemudian format cells hasil dengan Custom diisi [>5]dd-mmm-yyyy;; tekan ok

Regards,

Kid

[Agus Ramiyanto]

Terima kasih ya Mr. Kid.

U respon cepatnya dan ilmunya.

Segera saya coba.

Regards,

Agus Ramiyanto 

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsC2QRB2kD%2BBqZgtB4fab8ZV%3DoH9zLiVbayP17avaXU2g%40mail.gmail.com.

[Agus Ramiyanto]

Terima kasih Mr. Kid, cara yg kedua yg berhasil.

Regards,
Agus Ramiyanto

Pada Kam, 10 Okt 2024 18.56, Mr. Kid <mr.n...@gmail.com> menulis:

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsC2QRB2kD%2BBqZgtB4fab8ZV%3DoH9zLiVbayP17avaXU2g%40mail.gmail.com.