Mengambil data yang sama dalam range tabel

[Tyo Pong]

Dear admin dan rekan2,

Mohon dibantu untuk dapat mengambil data tanggal operasional yang sudah ada dalam tabel Operasional.

Salam

Tyo

[Nang Agus]

Dear Tyo,

coba di R3 diketik formula:
=IF(P3="","",INDEX($C$2:$N$2,MAX(INDEX((P3=$C$3:$N$111)*COLUMN($A$1:$L$1),))))

btw,

lebih mudah kalau pakai Pivot.

Regard.

Agus.

--
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/CABTMeLuZoduv%2Bo5tzzVFxRT0cd2TU873tkTHjxxbH4nSFTnq5A%40mail.gmail.com.