wiewie 0 Report post Posted March 5, 2013 (edited) salam...maaf byk2 x reti nk post gmbr cmna..hrp2 ada yg sudi bntu publish gmbr tu kt cni...ok,cmni..boleh x saper2 tlg tnjukkan formula yg sepatutnya digunakan apabila saya masukkan no peserta (sheet2) ke kolum NOMBOR (sheet1) secara automatik nama peserta tu akan masuk sekalu ke ruangan NAMA PESERTA dan SEKOLAH..kiranya sy x perlu lagidah taip nama peserta dn nama sekolah dia..just enter no peserta maka nama peserta dn nama sekolah akn masuk skali di ruangan sebelahnya.... harap dpt bantuan tuan2 sekalian... terima kasih. Edited March 5, 2013 by akuccputsedut make picture viewable Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 5, 2013 Ada ka formula kat Excel bleh buat gini... Vlookup bleh ke..?? aku pun tak berapa nak expert laa Excel.. pakai VB laa.. create macro skit bleh kot... tunggu kot ada yang lain punya pandangan bernas... aku nih takde la pandai sangat keje cuci cermin bangunan ja.. hihihihihi Quote Share this post Link to post Share on other sites
wiewie 0 Report post Posted March 5, 2013 (edited) Ada ka formula kat Excel bleh buat gini... Vlookup bleh ke..?? aku pun tak berapa nak expert laa Excel.. pakai VB laa.. create macro skit bleh kot... tunggu kot ada yang lain punya pandangan bernas... aku nih takde la pandai sangat keje cuci cermin bangunan ja.. hihihihihi ada bos..sy pnh guna..tp x reti nk guna formula apa...yg sy guna ni pun org lain yg buatkan..skg ni formula dia byk yg broken..carca merba jadinya...kena wt smula..ni yg nk blajar cara nk buat tu..nk kena setting balik smula!!huhu... err...tlg kluarkan gmbr ni plak bleh x..nk kasi detail ckit...tq bos!!hehe Edited March 5, 2013 by akuccputsedut make picture viewable Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 5, 2013 bos awak pernah guna.. hurrmm takde backup ke..?? kalau yang nih dah rosak.. Quote Share this post Link to post Share on other sites
wiewie 0 Report post Posted March 5, 2013 adeh..tula..mmg xder backup..tu yg jadi haaru biru nih!!huhu...klu x setel gak kena taip manual la..aduyaiii... Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 5, 2013 adeh..tula..mmg xder backup..tu yg jadi haaru biru nih!!huhu...klu x setel gak kena taip manual la..aduyaiii... takleh copy paste ke..?? kenapa nak kena type manual..?? Quote Share this post Link to post Share on other sites
wiewie 0 Report post Posted March 5, 2013 takleh copy paste ke..?? kenapa nak kena type manual..?? xleh sbb sy dpt data tu dlm bentuk helaian kertas!!huhu...collect dr setiap sek yg masuk pertandingn..diorg htr borang guna kertas!! waaa.... :25: Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 5, 2013 xleh sbb sy dpt data tu dlm bentuk helaian kertas!!huhu...collect dr setiap sek yg masuk pertandingn..diorg htr borang guna kertas!! waaa.... :25: oowwhh means data dah ada laa.. pastu ikut borang kat kertas keyin nombor pastu nak bagi kuar 2-2 tuh.. lookup jer arr... mana yang lain nih.. taknak tolong kaa nih.. dah aku tukang cuci cermin nih pulak tolong jawab kan bodo-bodo je jawapan aku.. huhuhuhu sedih.. Quote Share this post Link to post Share on other sites
wiewie 0 Report post Posted March 5, 2013 oowwhh means data dah ada laa.. pastu ikut borang kat kertas keyin nombor pastu nak bagi kuar 2-2 tuh.. lookup jer arr... mana yang lain nih.. taknak tolong kaa nih.. dah aku tukang cuci cermin nih pulak tolong jawab kan bodo-bodo je jawapan aku.. huhuhuhu sedih.. jgnla merendah diri sgt tuan!! huhu... ok cmni..data tu dh siap ditaip (ada mmbr yg rajin sgt!!)huhu..skg ni yg ditaip tu senarai utk peserta hari pertama je (game ni blangsung slama 4 hari).. manakala utk hari2 seterusnya peserta yg lepas k peringkat seterusnya dh x perlu taip nama dia lagi...just taip no peserta jer...then nama n nama sek dia akn kluar.. paham kot?hehe...tuan terang ckit cara wt vlookup tu...dh try tp x mnjdi..dh byk wt research kt tenet tp still blur lagi..:) Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 5, 2013 (edited) tuan tuan.. pemende hang nih... hang tak nampak ke muka aku skit punya cun tuh... hang dok tuan tuan bagai.. aku keje cuci cermin bangunan jer arr.. tinggi bangunan aku keje tuh.. tak baekk tau hang nak kata aku rendah2 kan diri.. aku keje tingkat 17th tinggi tau tak... huhuhuhu apa punya tuurrr... chaiitt... http://www.youtube.com/watch?v=g2YlBT7fiuk <-------- link to video tutorial... lagi step by step.. aku google jer nih... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutorial-part-i/ Edited March 5, 2013 by akuccputsedut Quote Share this post Link to post Share on other sites
dvdbane 86 Report post Posted March 5, 2013 mrah plak cput siput mne ad jantina lah.. :3: Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 6, 2013 mrah plak cput siput mne ad jantina lah.. :3: hahahhahaa... saja ja... lepas tension tak dapat pi sabah... hahahhahahaa...wei tolong laa dia nih jap.. aku tak pandai excel.. Quote Share this post Link to post Share on other sites
wiewie 0 Report post Posted March 6, 2013 hehe..jgnla marah puan cput ek!!..anyway, msih lg mncuba fungsi vlookup tu..try n error!!huhu.. Quote Share this post Link to post Share on other sites
akuccputsedut 147 Report post Posted March 6, 2013 hehe..jgnla marah puan cput ek!!..anyway, msih lg mncuba fungsi vlookup tu..try n error!!huhu.. adoyaii... nih lagi sowang... memang budak PDC nih kena cam satu virus panggil aku puan ka..??? tension aku.... :69: kalau taktau sangat aku pun tak sempat nak buat tutorial.. aku banyak keje nih..esok dah cuti... Quote Share this post Link to post Share on other sites
TJ-Ariff 40 Report post Posted March 14, 2013 hehehe... adik ku c ciputcomey dah marah.... :3: Quote Share this post Link to post Share on other sites