Alamat Aplikasi Berbagi

- kode siswa : =arrayformula(if(row(e:e)=1;"kode";(b:b&c:c&d:d&e:e))) 

- nama : =arrayformula(if(row(g:g)=1;"nama";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;3;0);"");""))) 

- nis_siswa : =arrayformula(if(row(g:g)=1;"nis_siswa";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;2;0);"");""))) 

- no_ujian : =arrayformula(if(row(g:g)=1;"no_ujian_siswa";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;4;0);"");""))) 

- tempat_lahir : =arrayformula(if(row(g:g)=1;"tempat";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;5;0);"");""))) 

- tgl_lahir : =arrayformula(if(row(g:g)=1;"tgl_lahir_siswa";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;6;0);"");""))) 

- keterangan : =arrayformula(if(row(g:g)=1;"ket";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;13;0);"");""))) 

- b_indo : =arrayformula(if(row(g:g)=1;"ind";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;8;0);"");""))) 

- b_ing : =arrayformula(if(row(g:g)=1;"ing";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;9;0);"");""))) 

- mtk : =arrayformula(if(row(g:g)=1;"mtk";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;10;0);"");""))) 

- ipa : =arrayformula(if(row(g:g)=1;"ipa";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;11;0);"");""))) 

- rata2 : =arrayformula(if(row(g:g)=1;"rata2";if(countif(db!$a$2:$a$91;"="&g:g)=1;iferror(vlookup(g:g;db!$a$2:$m$100;11;0);"");"")))