Jump to content
Sign in to follow this  
wiewie

Formula Ms Excel 2007

Recommended Posts

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....

 

 

Untitled_zps4ec81ae0.jpg

 

 

harap dpt bantuan tuan2 sekalian...

terima kasih.

Edited by akuccputsedut
make picture viewable

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

Untitled_zps1727abc0.jpg

Edited by akuccputsedut
make picture viewable

Share this post


Link to post
Share on other sites

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..??

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

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..:)

Share this post


Link to post
Share on other sites

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 by akuccputsedut

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...