Excel data validation based on another cellงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
อัปเดต 4 แบบฟอร์มออนไลน์ใน Javascript Update 4 online forms in Javascript. Remove 3 paragraph from 1 form and add 1 text field to another form. Example, what needs to be done: Adjust this form according to the picture attached. Possible long term collaboration ahead.
...สามารถ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - work report (weekly) - keywords ranking report (weekly) - need to see improved ranking result in 1 month to continue another month - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...an Excel sheet that requires detailed data input for the purpose of sales analysis. Key Requirements: - Data Analysis: The core purpose of this project is to provide a comprehensive analysis of sales figures. - Charts and Graphs: I require these sales figures to be effectively translated into visual representations, such as charts and graphs. Ideal Skills and Experience: - Proficiency in Excel: A strong understanding of Excel is essential for this project, as it will be the primary tool for data analysis and visual presentation. - Data Analysis: A background in data analysis will be beneficial for interpreting the sales figures and translating them into meaningful insights. - Visualization: Experience in creating charts and gra...
I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure th...
I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.
My Magento website is currently down due to a critical error. This error was showing for a short time on the screen: "Exception: Notice: fwrite(): write of 211 bytes failed with errno=28 No space left on device in /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/ on line 133 in /var/www/html/vendor/magento/framework/App/ Stack trace: #0 [internal function]: MagentoFrameworkAppErrorHandler->handler() #1 /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/(133): fwrite() #2 /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/(119): MonologHandlerStreamHandler->streamWrite() #3 /var/www/html/vendor/magento/framework/Logger/Handler/(88): MonologHandlerStreamHandler->write() #4 /var/www/htm
Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!
I am in need of an expert in Excel data entry. This project involves typing a mix of text, numbers, and formulas into an Excel sheet. Requirements: - Expertise in Excel: You should be proficient in Excel and comfortable with handling complex data entry tasks. - Attention to detail: Since the data entry forms an essential part of my project, I require someone who pays close attention to detail. - Data validation skills: It's essential to ensure the accuracy of the data. Therefore, you should be able to validate and perform error checking on the entered data. Ideal Skills: - Proficiency in Excel - Experience with data entry in complex Excel sheets - Strong attention to detail - Fam...
I have a large Excel sheet that needs to be populated with data. Your primary task will be to type in numbers, text, and dates accurately. Key Responsibilities: - Data entry for over 20 columns and 500 rows - Ensuring precision while typing in different types of data Given the nature of the task, there is no need for you to apply any formulas or functions to the data. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Attention to detail
I'm a job seeker looking for opportunities within the education industry. - You need to provide a detailed project proposal. - Previous work and experience is beneficial but not mandatory. - Experience in the education industry is essential. Your proposal should clearly outline how you can assist me in finding suitable jobs in the education sector. Please do not forget to include any relevant experience you have in the industry.
I am looking for an expert who can create MIS reports encompassing sales, financial, and inventory data. The frequency of these reports will be based on my requirements which can vary. Those equipped with excellent skills in data analysis, report generation, and detail orientation will be ideal for this role. Knowledge in handling Excel is a must as the reports need to be delivered in this format. Here's what is expected: - Data compilation and report generation as per my request - Proficiency in Excel for creating and delivering reports - Adherence to strict timelines for report submission - Maintain confidentiality of all the data involved If you have prior experience in creating MIS reports of these types, I would be very ...
you should start right away should have proficiency in core php, jquery, ajax and mysql budget INR 100 per hour, need to work for another 15 to 20 days
I'm in need of a skilled service professional to assist with my robotic palletising cell. Key Details: - Purpose and Issue: My robotic palletising cell is used primarily for packaging products. Recently, the system has been experiencing a range of issues, including error messages on the control panel, failing to pick with vacuum, reduced speed of operations and more. I need someone who can troubleshoot and diagnose these issues effectively, addressing them thoroughly. - Expected Service: I'm looking for a comprehensive maintenance service that goes beyond a routine check-up. You should be able to identify and resolve the root cause of these multiple issues, ensuring the system operates smoothly, efficiently and correctly again. Ideal Skills and Experience...
As an entrepreneurial business owner, I am in need of a talented designer to create the front cover of a document. This cover will be crucial for branding, and ultimately, capturing the attention of our clientele. It should feature: - Several logos: These should be incorporated seamlessly with vivid images to create an eye-catching and attractive front cover. I have the logos ready to send. - Must be able to send it back to me within 12 hours - A bold and vibrant style: Captivate the viewer's interest at first glance with a loud, bright, and energetic design. Candidates with strong experience in graphic design, logo design, and digital communications will be ideal for this project. An eye for aesthetics and a knack for design principles (balance, contrast, visual hierarchy, and emp...
For this project, I require a meticulous freelancer with skills in data entry, and specifically in converting images with somewhat legible handwriting into Excel data. Key Responsibilities: - Accurate conversion of handwritten text from images into digital format in Excel. - Ensuring the integrity of the data by carrying out data validation and verification. Required Skills: - Proven experience in data entry, particularly involving handwritten text. - An eye for detail for data accuracy. - Proficiency with Excel is mandatory. - Ability to decipher and transcribe somewhat legible handwritten text. This project suits someone with patience and diligence due to the level of legibility of the handwritten text.
I have a photo that I'd like to alter. This is purely a personal preference. Ideal Skills: - Strong image editing and manipulation skills - Proficient in Adobe Photoshop or similar software - Experience with photo restoration is a plus The photo is taken indoors. The task involves removing one person from the photo and replacing it with another. I would prefer the final version to be in JPEG format. I want the girl in the orange dress removed and replaced with the bride
We are seeking a skilled PHP/Python developer to create a web-based solution hosted on an Ubuntu server that enables users to create Indesign documents based on existing InDesign templates then download the customized document. Please place a bid only if you are familliar with Indesign API Freelancers interested in this project should ideally have experience in: - Developing web applications. - Implementing high levels of customization in a web tool. - InDesign, especially its formatting features.
I require a proficient developer to build a robust face recognition system to...recognition system to enhance the security of my web platform. This feature is expected to be implemented as a mandatory measure for all users, specifically on the login page. Ideal Skills and Experience: - Proficient in web development - Prior experience with integrating biometric systems, particularly face recognition technology - Strong understanding of data privacy and security protocols - Experience with user authentication procedures and systems. Tasks and Deliverables: - Develop a face recognition system for the website - Incorporate the system into the login page - Ensure this feature is mandatory for all users - Prioritize security and user data protection - Provide updates and ...
...for a skilled Python developer to build an application that is capable of placing trades on multiple cryptocurrency exchanges, specifically Binance, Coinbase, and Deribit. Key Features: a Python application that connects to Deribit. It should allow me to: • Pull live instrument prices o Would want to be able to pull many instruments at once – I.e. every futures expiry for all listed currencies / All option strikes across multiple expiries • Pull my positions / balances / margin usage • Place / view / amend / cancel orders o Send multiple orders at once o Cancel specific orders o Cancel all outstanding orders • Record market / Position / transaction data Latency / Speed of execution is important so wil...
long term , full time flask developer needed to build ecommerce backend you should start right away should have proficiency in flask, jquery, ajax and mongodb budget INR 100 per hour, need to work for another 15 to 20 days
I'm in need of a webpage that will serve as a showcase for my individual Matterport based digital twin spaces. The spaces exist within a hotel but it is not possible to scan the entire building. From the facade image I need the user to be able to locate a label or thumbnail of each space and click there to enter the digital twin. There will be 5 different room types and two different dining and bar spaces I can provide the links for the spaces and Matterport instructions on embedding digital twin spaces. This webpage needs to provide basic interaction, such as walking through and zooming in the digital twin spaces. Key Requirements: - Webpage should host Matterport digital twin spaces built in Unity - Digital twin spaces should support basic interaction (e.g., wa...
I'm seeking guidance and support to excel in the AI certification, emphasizing on concepts and theories. - The primary focus of this project is on improving my understanding of AI principles, concepts, and theories. - As I'm aiming to complete the certification, I need a mentor who can explain complex AI concepts in a clear, concise, and readily understandable manner. - Given the current circumstances, I'm specifically looking for online resources to guide me through this journey. Ideal candidate for this project should have: - Proven experience in Machine Learning, ideally with certifications themselves. - Excellent teaching and mentoring skills, particularly in breaking down complex topics. - Good understanding of online learning platforms and resou...
...skilled freelancer to create a custom quoting template in Microsoft Excel for my business. The template should be intuitive, easy to use, and visually appealing. Key Features: - The template must be fully customizable in design, enabling me to adapt it according to my branding and specific needs. - I'd like the template to incorporate conditional formatting for data visualization. This feature will help better present the data, making it easier to understand and interpret. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly in creating templates. - Experience in designing visually appealing and user-friendly templates. - A strong understanding of how to implement conditional formatting for effective data visualization. ...
...and deployment data to ensure compliance with licensing agreements and identify potential areas of risk or non-compliance. Roles and Responsibilities: • Conduct software audits for client organizations to assess compliance with software licensing agreements. • Analyze software deployment data, license entitlements, and usage metrics. • Verify the accuracy of software license records and documentation. • Identify discrepancies, unauthorized software usage, or potential non-compliance issues. • Prepare detailed audit reports outlining findings and recommendations. • Collaborate with clients to resolve compliance issues and implement corrective actions. • Stay updated on software licensing rules, regulations, and industry best pract...
I am in need of a skilled professional who can assist me in setting up the Odoo Book...Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requiremen...
I am in need of a proficient excel wizard who can simplify my day to day tasks. While the specifics aren't in place, ideally I'm looking for someone who can efficiently perform data entry, come up with efficient formulas and functions, and provide comprehensive data analysis. Proper data formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Experience with data...
...processing, and data validation. Key Responsibilities: - Investigating and diagnosing core functionality issues related to user authentication, payment processing, and data validation. - Implementing effective bug resolution strategies that uphold security, performance, and user experience standards. - Ensuring that all fixes are thoroughly tested and do not compromise any other aspects of the system. Skills and Experience: - Strong background in Laravel development, particularly in resolving high complexity bugs. - Proficiency in working with user authentication, payment processing, and data validation in Laravel. - Familiarity with best practices in bug resolution, including thorough testing and validation. - Proven ability to work i...
I am looking for a skilled and experienced...create a diverse range of characters. - The character models should be compatible with the UE5 skeleton. - Rigging for all the characters is needed so they are ready for future animations. I am only offering $30 per character, because the same body will be used for 14 of the 20 characters. And another body for 6 of the 20 characters. The rigs will be the same for everyone. The biggest work will be in modeling the head of each character. The arms and knees will basically change color just depending on the skin of each character. Ideal Skills: - 3D modeling and character design. - Proficient in Blender. - Experience rigging characters for Unreal Engine 5. Please ensure you include relevant examples of past similar projects when...
I need an expert data analyst to clean and integrate data from excel files into a Power BI dashboard. Key Project Details: - The primary data source is excel files. It's crucial that the freelancer is proficient in Excel for extracting, cleaning, and transforming the data. - Dataset is farmers data including demographics and crop details. - The main focus of this project is on data visualization. I need the dashboard to present the data in a clear, visually engaging way. - The dashboard will be updated quarterly. Ideally, the freelancer should set up a process for this to be done efficiently and accurately. The task involves: - Understanding the data and the requirements for visualization - Cleaning...
Bonjour, je suis archéologue. J'ai du texte, des photos, des images, un document Excel a insérer dans un seul rapport paginé. Il faut faire la mise en page et transformer en PDF.
I'm seeking a freelancer who can help with a data analysis project, translating numerical data from one sheet to another. - The main task for this project is copy texting, involving the transfer of numerical data. The ultimate goal is to enhance data analysis. This will require a high level of accuracy and attention to detail. - The results of the data analysis should be presented in the form of charts and graphs. Thus, experience with data visualization would be a great asset for this project. - The primary data type that you will be working with is numerical. Your understanding of numerical data and how to interpret it will be crucial for the success of this project.
I'm looking for an Excel expert to create a costing sheet for a product. Key details for the job include: - It's mainly a costing sheet that will help me calculate the final price of my product based on material costs. Ideal Skills and Experience: - Proficiency in Excel - Solid understanding of financial calculations - Previous experience in creating costing sheets for products Looking forward to receiving your bids.