Bisa. Ketik pada Senin s/d Jum'at di sel A1 s/d A5 Di sel B1 ditulis formula : =INDEX($A$1:$A$5,COUNTA($A$1:$A$5)) Di sel B2 ditulis formula : =INDEX($A$1:$A$5,COUNTA($A$1:$A$5)-ROW(A2)+1) Copy sel B2 ke sel B3 s/d B5 Salam, Hendrik Karnadi
--- On Tue, 21/6/11, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: [belajar-excel] Tanya donk,,Tampilkan hasil membalikkan urutan data To: [email protected] Date: Tuesday, 21 June, 2011, 4:34 PM Master" sya mw tanya nich,,,misal di kolom a itu ada nama hari senin,selasa,rabu,kamis,jum'at,,,,nach ada Ñǥαќ>:/ rumus supaya di kolom b secara otomatis datanya jadi sebaliknya jadi jum'at,kamis,rabu,selasa,senin,makasih Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!
