Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~1K People Reached
Favorite Tags
Member Avatar for Jemuel

hello everyone, I am having a problem regarding excel,I want to get the (network name) base on the network prefix of the (phone number) column using the value of the third column which is the (network) Sample output: Phone Number | Network Name | Network Prefix | Network Name 9162123212 …

Member Avatar for gerbil
0
110
Member Avatar for Jemuel

hi, Can anyone help me about my other problem about excel? I'm trying to create a simple inventory system using microsoft excel 2010, and i have a sheets naming stocks & sales. i want to make it automatically subtract the value from the sheet(stocks) when i input the quantity of …

Member Avatar for gerbil
0
132
Member Avatar for Jemuel

hi, Please help how to solve my problem about how to limit 11 digit number inside excel cell. i want to enter values like mobile number starting 0########## and deletes the excess numbers. thanks in advance

Member Avatar for Jemuel
0
123
Member Avatar for Jemuel

what did I've done wrong with this code? =IF(OR(ISBLANK(C9),ISBLANK(B9)),"",IF(ISBLANK(C9),D9-TODAY(), "Reactivated")) I want to make an event that if b9 and c9 is empty, the value would be empty. if only c9 is empty, then the output would be the remaining days left between the two dates, and if the two …

Member Avatar for ddanbe
0
108
Member Avatar for Jemuel

please help i am trying to extract data from database into multiple columns but i can't get it. All your helps is very needed. Thank you! this will be the output (actual value of my serial table) 1233BED13DS01132 1233BED13DS00878 1233BED13DS00012 1233BED13DS00097 1233BED13DS01315 1233BED13DS00461 1233BED13DS00835 1233BED13DS00010 1233BED13DS01313

Member Avatar for diafol
0
221
Member Avatar for Jemuel

I am having trouble on how will I solve this problem. I want only to refresh the value of listbox after adding a value from textbox using onclick() on an image. <form id="UpdateDetails"> <input type="hidden" name="id"> <input id="adnew" type="text" autocomplete="off" name="addnew" class="xx"> <img id="img" onclick="addnew()" src="images/icons/add-icon.png" style='padding:0 0 0 10px;height:15px;width:15px;cursor:pointer;' …

0
156
Member Avatar for Jemuel

Please help! i am troubling about on how can i execute my sql script properly. Thanks!Here's my code $sql="INSERT INTO inventory(account_number,serial_number,locator,remarks,`date_assigned`) VALUES('$accountno','$serial','$locator','$remarks',NOW())"; $sql.="INSERT INTO action_log(action,username,`date`) VALUES ('assigns the box($serial) to $accountno','$user',NOW())"; $sql.="INSERT INTO account_logs(action_log,account_number,username,`date`) VALUES('Assign','$accountno','$user',NOW())"; if(mysql_query($sql)){echo "Successfully Assigned!";} else{echo "Insertion Failed!";}

Member Avatar for Jemuel
0
209