Vlookup duplicate function excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
หาคนเขียน function Yii2 framework ไปไว้ใน shortcode wordpress ครับ เว็บไซต์ทำงานได้ปรกติครับ
สวัสดีครับ หาคน รับปรับแต่ง prestrashop หรือโมโครงสร้าง theme เล็กน้อย ครับ ตอนนี้เป็น prestrashop 1.6.1.5 ครับ แต่สามารถเปลี่ยนเป็นรุ่นที่ท่าถนัดได้ ถ้าถนัดเป็น 1.7 ก็ได้ครับ เดิมที่ ลงเอง ทำเองแล้ว ยังทำได้ไม่ดีเท่าที่ควรครับ มีความต้องการ อยาก เพิ่มเติม บาง function ให้ เหมาะสมกับความต้องการของลูกค้าครับ สนใจ ติดต่อ num2029@ คุณบอม 0887893566 ขอบคุณมากครับ
1. การสั่งซื้อ ระบบไม่สามารถเเปลภาษาจากจีน - ไทย เเละไม่สามารถดึงข้อมูลจากเว็บจีนมาเเสดงผลที่หน้าเว็บไชต์ของทางเรา 2. เพิ่ม. function สำหรับเชลล์ 3. ติดตั้ง SSL
1. การสั่งซื้อ ระบบไม่สามารถเเปลภาษาจากจีน - ไทย เเละไม่สามารถดึงข้อมูลจากเว็บจีนมาเเสดงผลที่หน้าเว็บไชต์ของทางเรา 2. เพิ่ม. function สำหรับเชลล์ 3. ติดตั้ง SSL
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องการทำแอพเกี่ยวกับการเล่นเกมแล้วสะสมแต้ม คล้ายกับแอพ adpocket แต่เพิ่มเติม function
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
design website, built function for usability, 2 week done. ออกแบบและสร้าง เว๊ปไซร์ ตามคอนเซ็ปของลูกค้า
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการให้พัฒนา ระบบฟังภาษาไทยผ่าน php โดยเมื่อฟังคำที่เป็นคำสั่ง เช่น เปิดไฟ ให้ไปสั่ง function php ให้ทำงานต่อ ทางผมมี function อยู่แล้ว ขาดส่วนที่รับ input เป็นเสียงเพื่อไป trigger ให้ function ที่เตรียมไว้ได้ทำงานต่อ
ต้องการให้พัฒนา ระบบฟังภาษาไทยผ่าน php โดยเมื่อฟังคำที่เป็นคำสั่ง เช่น เปิดไฟ ให้ไปสั่ง function php ให้ทำงานต่อ ทางผมมี function อยู่แล้ว ขาดส่วนที่รับ input เป็นเสียงเพื่อไป trigger ให้ function ที่เตรียมไว้ได้ทำงานต่อ
Creating the corporate website for a chemical company with eCommerce function. Able to search 300000+ items and show suggested result while typing, login to see price, can generate a quotation online, has add to basket order function and send out email confirmation . If possible, the product data will link to an ERP database ( Winspeed). Has live chat function and customers can subscribe to our newsletter. Back office can pull the quotation data, order data and customer data. The website will have CMS to manages pages like news, promotion, career opportunities. Also include contact form and catalog request form. Also need graphic design for banners. And also do SEO. สร้าง website บริษัทโดยมี eCommerce function สำหรับสินค้าประเภทเคมี 300000 รายการ ส...
...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...
I'm looking for an experienced Linux professional with a knack for data analysis to assist me with my projects. Ideally, you will possess: - In-depth knowledge and understanding of L...Experience dealing with numerical data. - Proficiency in data sorting, statistical analysis, and data visualization techniques as these will be a fundamental part of the job. In addition, knowing how to decode SecretKeys with the bs58 library is a crucial aspect of this project. This task represents a core operation you will be required to perform with the numerical data. Your ability to execute this function deftly will significantly impact the project's success. I am looking to begin the assignment as soon as I find the right fit, so please ensure your bid reflects your best offer and ...
I am looking for a skilled developer who can create an advanced chatbot for my PHP-based CRM. The key aspects of this project include: - Chatbot for Customer Support: The primary function of this chatbot will be to handle customer inquiries and provide advanced problem-solving support. - Integration with PHP CRM: The chatbot needs to seamlessly integrate with my current CRM system. - GPT AI: The preferred technology for the chatbot is GPT-based AI. - Customization: I would like the chatbot to be fully customizable and easy to program for future updates and modifications. Ideal Skills: - Proficient in PHP, GPT AI, and CRM integrations - Experience in developing advanced chatbots for customer support - Ability to create customizable and easy to program solutions - Strong commu...
I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old ...
...000 products from 5-10 stores: The tool should be able to analyze and compare prices for a substantial number of products across multiple listed stores. - Avoiding Captcha and ad blockers: The tool should be designed to function effectively while avoiding common barriers like Captcha or ad blockers. - User-friendly filters: The tool should offer a variety of filters to help users refine their search results. - Display results directly on product pages: The comparison results should be integrated and displayed on the corresponding product pages. Or through a widget function. Project Scope: - Estimated 3,000 to 8,000 pages: The tool should be scalable enough to handle a substantial number of pages, ensuring it can support the growth of our product database. Ideal skil...
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I am seeking a F...create a custom package to integrate with Flutter Flow. The project will primarily involve integrating the package with Flutter Flow and potentially other services as well. The specific requirements for the package are not specified, and the design or wireframe for the integrated Flutter package is also not yet provided. This means you will have the opportunity to collaborate on the design and function of the package. Given the nature of the project, you should have a strong background in Flutter development, and experience in integrating packages with Flutter Flow will be a plus. Creativity, good communication skills and the ability to work collaboratively are also important. Please specify your background in Flutter development and examples of your work when...
...project is on two key aspects: - **Wireless Connectivity**: Your expertise in designing wireless systems is crucial for this project. The RFID system needs to communicate with our central hub seamlessly, so ensuring a reliable wireless connection is a priority. - **Energy Efficiency Optimisation**: The system to be developed should be as power-efficient as possible. We need the RFID system to function optimally while conserving energy, ensuring long-term sustainability and performance. **Specifics of the Project**: The project is specifically for an RFID system, which comes with unique challenges and requirements. Since the system will not require encryption for secure data transmission, the focus is primarily on a strong wireless connection and energy efficiency. **Ideal Sk...
Looking for an experienced HTML5 developer to create a customizable video player to be embedded on a website. This video player should be able to handle a playlist function and advances to the next video automatically after a video has ended. Key Features: • Playlist Management: Auto-play next video feature is crucial. • Subtitles Support: Built-in support for video subtitles. Ideal Candidate: • Proven experience in HTML5 and JS. • Familiar with video player development. • Understands user interface and experience design.
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
...Copy pagination from existing website to a new website. (in ) - Float Player: This function enhances the user experience by ensuring that the media player remains visible on the screen even while scrolling. (parts in + + ) - Generate Thumbnail: The ability to automatically generate thumbnails for posts, easing the process of content management. () - Edit Post Generate Thumbnail: This function allows users to make changes to their thumbnails easily. () Specific Requests: - The desktop existing layout remains the same it has been done through elementor, the mobile/tablets version have to be edited by you. - The pagination function should be applied to the Home Page of the new website. Ideal Candidate: - Proven experience
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!
I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.
I'm experiencing an issue with my website, which is built on Sitejet accessed via my c panel. Despite successful form submissions, I'm not receiving any email notifications. I have checked my spam folder...via my c panel. Despite successful form submissions, I'm not receiving any email notifications. I have checked my spam folder, but the notifications are not being mistakenly redirected there. Ideal candidates should be well-versed with: - Debugging on Sitejet. - Resolving email delivery issues. Experience with similar projects is preferred, alongside a good understanding of how contact forms function, specifically on the Sitejet platform. The required fix should ensure reliable delivery of email notifications upon form submission. Resolving this issue promptly an...
I'm in need of a single screen Android application. The primary function of the app is for users to log in using their Facebook account. Upon successful authentication, the app should display the user's email address. Key requirements: - Single screen Android application - Facebook / Instagram / Google login integration - Display user's email address post-login Ideal freelancer for this project: - Proficient in Android development, particularly single screen applications - Experience with social media login integrations, specifically Facebook / IG / Google - Familiar with presenting user-specific information on Android applications - Excellent communication skills to clarify any aspects of the project if needed.
I am seeking a F...create a custom package to integrate with Flutter Flow. The project will primarily involve integrating the package with Flutter Flow and potentially other services as well. The specific requirements for the package are not specified, and the design or wireframe for the integrated Flutter package is also not yet provided. This means you will have the opportunity to collaborate on the design and function of the package. Given the nature of the project, you should have a strong background in Flutter development, and experience in integrating packages with Flutter Flow will be a plus. Creativity, good communication skills and the ability to work collaboratively are also important. Please specify your background in Flutter development and examples of your work when...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with ...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
Development a human anatomy VR application for oculus platform. When player in the app, they can choose a male or female anatomy. Then, choose the system function. Subsequently, anatomy of the system function will appear. Then player can click expand to isolate the parts with info panel to show name of organ. Then, player can close and choose other system or choose to see system of another gender. Arabic text of organ name and system name is to be provided prior or during development. Final delivery in apk.
