Bisa dengan pifot tbl or formula = HLOOKUP ( $ C6 ,data1! $B$4 :$C$9 ,COLUMNS( $C6 :D6 ),0)
Pada cell d6 sheet2 br. odong
Bls: [belajar-excel] Kolom ke Baris dg link antar sheet
'[email protected]' [email protected] [belajar-excel] Wed, 18 Jun 2014 21:02:24 -0700
- [belajar-excel... 'Moelyadi, CITRA' [email protected] [belajar-excel]
- Bls: [bel... '[email protected]' [email protected] [belajar-excel]
- Re: [bela... 'Bagus' [email protected] [belajar-excel]
