Excel limit cell value 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 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
I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.
SUMMARY OF PROJECT: The purpose of this project is to allow multiple users to complete a daily spreadsheet (split into 3 tabs). All users will share and complete the same spreadsheet daily. I have attached the following, please review before you bid: - SPREADSHEET SYSTEM - BRIEF V1.0, PHASE 1 - SPREADSHEET SYSTEM - FLOW CHART - SPREADSHEET TEMPLATE
As a healthcare staffing provider, my main objective is to generate leads and inquiries from carehome managers. To efficiently achieve this, I am seeking a proficient freelancer for the task. - Skills: Experience in B2B marketing and understanding of carehome operations and their needs. - Task: Create and execute a marketing strategy that can effectively showcase our value proposition. Specifically, our focus is on promoting our wide range of healthcare staffing solutions to carehomes. Through this we aim to fill their staffing needs and eventually foster long-term business relationships.
I have various Excel sheets that I need organized into a single Word document. I'd like them structured in a way where each category has its own sheet. Key requirements: - Transitioning data from Excel to a Word document - Organizing the data by category, with each category on its own page - Incorporating visual elements like charts and graphs Ideal Skills: - Proficiency in Excel and Word - Strong organizational skills - Experience with data visualization - Ability to create visually appealing documents
I'm looking for someone...data entry from various sources into Microsoft Excel. The data is predominantly text-based and needs to be input accurately. Key Responsibilities: - Manual data entry from various sources into Excel - Ensuring accuracy and consistency in data entry - Organizing and categorizing data appropriately Ideal freelancer should: - Be proficient in Microsoft Excel - Have experience in data entry - Be detail-oriented and accurate in data input - Understand the importance of maintaining data integrity The output for this project should be a PDF document. If you have experience in creating PDFs from Excel, that would be a plus. Accuracy and attention to detail are extremely important for this job. Please mention your experience in ...
Hola, María, necesitaría el trabajo de este excel: https://docs.google.com/spreadsheets/d/1tnP73xrnE0SGNuynpLpnl1r7mThhi4liPCQCYjTRdvE/edit#gid=1193400678 Gracias,
I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.
As a client, I'm seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same...end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familiarity with data cleaning and visualization libraries and tools. To thrive in this role, you must be a highly analytical thinker with the ability to separate noise from signal in dataset and excel at drawing clarity out of com...
I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.
...and sound effects to enhance the overall production value of videos • Ensure videos are optimized for online viewing, including aspect ratio, colour correction, and compression • Stay up-to-date with the latest video editing trends and techniques to bring new and innovative ideas to the table • Collaborate with the production team to ensure quality and requirement of the video are met effectively. • Incorporate the feedbacks of Video Producer and Team lead into the revised video • Creating and maintaining project file, changes, and revisions to video throughout the editing process • Ensure all videos are edited in a timely manner and meet deadlines • Continuously analyze and improve the performance of YouTube content. • Ability to capitaliz...
Who Are We? PeaceGeneration Indonesia is a social enterprise engaged in learning media, training, and peace education campaigns. Since 2007, PeaceGen has been actively working with various donors and strategic partners to promote peace in Indonesia. We currently have several projects focusing on capacity building for socio-emotional learning using the 12 Basic Values of Peace approach. The 12 Basic Value of Peace consists of the following: (1) Accepting Our Self (2) No Suspicious No Prejudice (3) Ethnic Diversity (4) Religion Differences (5) Gender Differences (6) Social Status Differences (7) Group Differences (8) Celebrating Diversity (9) Understanding Conflict (10) Reject Violence (11) Admit Mistake (12) Apologize.
I'm in search of a full-time Editor and graphic designer to join our team. Just bid if you think you're eligible and if you're okay with the ...you're eligible and if you're okay with the salary. The ideal candidate should be able to commit complete tasks by daily basis. Looking for a long time collaboration Roles & Responsibilities: - UI/UX - Video Editing (animation, 2d, 3d, reels, shorts) - Logo design and branding Please share: - Your portfolio - Your relevant experience - Any detailed project proposals that you believe may add value to our collaboration. Write "hi exurid" in starting of your proposal. If you're a talented and dedicated editor and graphic designer looking for a full-time position, I'd love to hear from you. (...
...trading processes using the Zerodha Excel API. As I'm unsure of the API's development, I need a freelancer who is experienced in API integrations and has a good understanding of automated trading systems. Key Elements: - Automation: The primary goal is to automate trades based on predefined criteria. This involves developing a system that can analyze market conditions and execute trades automatically. - Zerodha Excel API: As I am unsure about the development of this API, you should have a good understanding of it or be able to quickly grasp its functionalities. - Trading Experience: It would be beneficial if you have prior experience in developing automated trading systems. - Predefined criteria: The system should be able to automatically buy and s...
I require a skilled individual who is proficient in Excel to analyze market research data. This work requires a keen eye for detail and understanding of advanced analysis techniques. The main objective of this project is to provide precise quantitative summaries of the market research data. Your responsibilities will include: - Receiving and understanding the raw data provided - Analyzing and interpreting complex data sets - Producing quantitative summaries and reports based on your findings Ideal Skills & Experience: - Proficient in Excel - Previous experience in data analysis - Good understanding of market research principles - Excellent task management skills - Experience in generating data-driven reports. This project is ideal for freelancers wi...
I need an experienced web developer to resolve a critical issue on our website that uses a JavaScript framework and PHP. All files and the database have been transferred from one URL to another, but the website is now malfunctioning. I need this fixed as soon as possible. Key Requirements: - Expertise in JavaScript framework (Prototype) and PHP - Strong troubleshooting skills - Proven experience in resolving website migration issues Ideal Skills: - Familiarity with common web browsers like Google Chrome, Mozilla Firefox, and Safari - Ability to work under tight deadlines The issues we're experiencing are: - Layout appears broken - Interactive elements not working - Content not loading Please only bid if you can start immediately and have a proven track record of fixi...
I'm in desperate need of a seasoned writer to help with my online work. This might include different kinds of writings but preference will be given to a jack of all trades. Let's break it down: • Required Skill: Expertise in a broad range of writing styles is a plus. As the specific style of writing needed was not specified, the ideal candidate should be able to switch from one style to another effortlessly. • Purpose of Writing: The writing should be able to fill up free time. This suggests that the content must be highly engaging and captivating for readers to keep coming back. Therefore, the ability to create such content is paramount. In conclusion, an experienced versatile writer, who has a knack for producing entertaining content, will be an ideal fit fo...
We are looking for a designer to work on an existing tech template. We have a Figma file and would customize it for our use case Only experienced Figma designers
...correct answer (the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Successful project: - All questions in there, in correct order from the PDF. - No typo...
I'm looking for a reliable freelancer to help with a small-sized project involving Excel data entry. The information will be shared via online documents. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail is a must - Ability to handle small-scale tasks efficiently
I'm in need of a skilled logo designer who can create a professional, text-based logo for my technology company. This logo should reflect a professional ambience, and requires a hassle-free, engaging style that instantly captures attention. Ideal Skills: • Substantial experience in graphic design, particularly with textual logos. • A keen understanding of the technology industry and ability to portray its professionalism. • Proven ability to transform conceptual ideas into powerful visual representations. This is not a project for heavy graphics, but rather font and layout focused creativity. Interested? Let's connect and discuss the details!
I'm on the hunt for a talented designer, proficient in creating modern and minimalistic text-based logos. The emphasis of this task shall be: - Crafting a logo that exudes a sense of reliability and trust; the core of our brand identity. - Proficiency in minimalistic design elements. I invite experienced designers who have a keen eye for simplicity, and who are able to effectively communicate a message of trust and reliability through their work. Your portfolio should demonstrate exceptional skill in crafting text-based logos with a modern and minimalist aesthetic. I look forward to transforming my brand vision into reality with your creativity and expertise.
I'm looking for a skilled sales closer with a strong tra...dealing with are pharmaceuticals, so any previous experience in this specific area is highly desirable. Your success will be measured on your ability to generate sales, retain customers, and ensure their satisfaction with our products. Ideal skills for this project include: - Proven track record in retail sales, ideally with experience in both brick-and-mortar and e-commerce - Strong communication and negotiation skills - Ability to understand and communicate the benefits and features of pharmaceutical products - Experience in selling healthcare or pharmaceutical items would be highly beneficial If you believe you have the skills and experience needed to excel in this role, please do get in touch. I look forwar...
I'm seeking a skilled photographer for an outdoor city family photoshoot in the evening hours. Familiarity with urban-style photography and the ability to create impactful portraits during the golden hour is ideal. Key requirements: - Skilled in family portraits and outdoor photography - Experience in capturing images in the evening lighting - Proven ability to work in urban environments - Availability for the scheduled date and time Your portfolio of similar work would be appreciated for review.
I am looking to commission a skilled Pine script developer to build a trading strategy for me on TradingView based on the Weighted Moving Average (WMA) Indicator and Anchored Volume Weighted Average Price (AVWAP). Key Requirements: • Develop Pine script strategy for TradingView that will generate both long and short trade signals based on WMA and Anchored VWAP. • The strategy should encompass a simple backtesting functionality, optimization is not needed. Ideal Candidate: The ideal candidate for this job will have a significant familiarity with: • Pine script programming and development; • TradingView platform; • WMA and Anchored VWAP indicators. This role requires a detail-oriented professional with a track record in de...
I wil...changes daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines is crucial. So, if you have good experience with Excel, particularly with format...
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
I want to add 2 RSJ beams to my house to create a canopy above the proposed external terrace area. chem fix bolted back to the concrete structure of house. The house is a newly constructed single story property using ICF (insulated concrete formwork) with 150 mm thick concrete core and 80 mm extruded polystyrene on the outside and the inside. Generally, there is no rebar in the structure other than integral lintels and columns. The proposal is to add a minimal RSJ/UB steal structure to form a canopy structure. This new metal structure shall be fixed to the existing concrete structure by drilling and Chemfix with appropriate sized threaded bar, nuts and washes. It should be noted that 2nr concrete deep pad foundations have already been installed to align with the 2nr vertical RSJ...
I'm looking for a JavaScript developer with experience in ARIS-based scripting. The script I have needs to be modified and expanded like so: - Addition of custom functionality - There are certain tasks this script must perform which it currently doesn't. - Enriching the user interface change color codes, add more tables etc. list of 8-10 changes needs to be done. I need more tables incorporated into the script that pull additional information. Ideally, you'll have a demonstrable knowledge of ARIS-based JavaScript and a strong understanding of UI development. Accomplished script performance is a must.
...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel and ...
