Excel merge two tables based on one columnงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...chat client for me. The client will primarily be text-based, allowing group communication between multiple users. Key Features: - Group Chats: The primary function of this chat client is to facilitate group chats. Therefore, it should support multiple users in a single conversation thread. - User Mentions: I'm also looking for the implementation of user mentions, which will enable users to tag others in a message, signaling their attention. Additional Features: - File Sharing: The ability to share files within the chat would be a very useful feature. - Chat Moderation Tools: I'd like the chat to have basic moderation tools to oversee the group chats and manage user interactions. Ideal Skills and Experience: - Proficiency in text-based chat client development...
I am seeking a highly meticulous and efficient Data Collection ...research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the j...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...grant opportunities in areas that support IT, Digital Marketing & SEO programs. Essential Functions * Understand the history, structure, objectives, programs and financial needs of our organization. * Research grant opportunities from Ontario/Canadian government agencies. * Draft grant proposals and supporting documents based on the funding requirements of the organization. * Submit proposals to grant coordinators for approval. * Respond to internal and external queries on drafted and submitted proposals. * Maintain positive relationships with fund providers and other stakeholders. * Maintain records and submit reports related to grant opportunities. * Researches and identifies new Canadian Government small Business grant funding prospects to match our busines...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database syst...status when shipped and delivered. 5. Reports and Analytics - Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables...
I'm on the lookout for a skilled Flutter developer to create a cross-platform (iOS and Android) restaurant application with intuitive and user-friendly interfaces. This app serves as a comprehensive solution for consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart program...
Java based app backend for tourism activities need 2 things. 1 - add a copy activity in activity page to copie a existing activity content to a new one 2 - migrate backend from vps centosOS to cpanel based hosting.
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas an...
I'm seeking a skilled developer to build a trading bot for the Solana web3 infrastructure. This project involves: - Smart contract deployment - Token and wallet integration - Algorithmic trading bot development Your expertise should include proficiency in creating trading bots, with a deep understanding and prior experience in implementing auto-buy and sell features. Knowledge of trend following, mean reversion and breakout trading strategies is crucial for this role. Additionally, I expect familiarity with the Solana ecosystem to ensure seamless integration. Your input will be vital in positioning the bot precisely within the market dynamics.
...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...
I need to liquidate (sell) ) some the goods in Manila, need someone with experience in liquidation this information and quantity: The price we liquidate is given in column G, This is a very cheap price compared to the price I imported, and I guarantee it is the cheapest in the wholesale market Currently the goods are in my warehouse in Manila, please contact us for more detailed discussion
Necesito soporte para crear una web sencilla en WordPress utilizando Elementor, es suficiente con mostrar toda la información en una única página. El dominio y hosting ya estarán contratados. También se proporcionaran los textos e imágenes necesarios.
I'm seeking a skilled graphic designer to create an icon-based logo for my company. The desired logo should meet the following criteria: - Style: The overall aesthetic should be casual, veering away from the rigid structure of formal styles. I'm interested in a more relaxed, amusing approach that embodies a cheerful spirit. - Color Scheme: Adorn the logo with bright and vibrant colors. These colors should bring the logo to life, making it more appealing and eye-catching to the audience. - Type: The logo should largely be icon-based, focusing more on imagery than text. Ideal Skills: - Graphic Design skills are necessary, notably in creating logos. - Familiarity with designing icon-based logos. - An ability to balance color, design aesthetics, and imag...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Techni...
...professional who can breathe life into a 20-page Microsoft Word document (no need for you to research, I need just your creativity to adjust the document). Here's what I'm after: • Use of custom fonts for a unique look • Development of a color scheme that permeates the document • Designing an interesting yet professional header and footer and unique cover page On top of this, I need someone with proficiency in inserting tables and graphs into the document, making it more interactive and engaging. The attached document will give you an idea about what I am looking for (DON'T make it as same the attachment, just I need something similar to it) Ideal Skills for this project: Microsoft Word, Graphic Design, Typography. Experience in similar p...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should h...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.
Sure, here's a revised version: Experienced WordPress Designer and Developer Needed I am seeking an experienced WordPress designer and developer to create three websites based on the theme provided The theme will be purchased prior to the project start. Website 1: This website is for a web agency. It will closely follow the theme's layout, with customized images and content provided by me. Website 2: A hotel broker website. New icons will be required for this site, designed by you. Images will be provided by me, possibly requiring some Photoshop work. New content will also be inserted, provided by me. Website 3: A corporate
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
Budget is is in project. Don't place a placeholder amount / bid. I am here to select and not to increase budget. This project is for next 5 hours max. If you can not work now no need to bid. My developer will be available then but I am impatient and ready to hep him NOW. I am looking for a professional who can help me with troubleshooting and possibly resolving issues in my web-based API around E*Trade. We will connect/ login/ get token to use whatever needed. The task is relatively brief and should not take more than a few hours for an experienced developer. Please provide details of your relevant experience to help me make an informed decision.
...experienced freelancer to develop an All-in-One AI-based HR Solution Platform entirely from scratch. This platform will serve as a comprehensive tool to streamline various HR processes and enhance efficiency across our clients' organizations. Requirements: The freelancer is required to develop a single platform capable of providing web and aap based services for product owner and client user interface, with the following functionalities: 1. Recruitment and Applicant Tracking: Streamline the recruitment process, from job posting to candidate selection, with robust applicant tracking capabilities. 2. Employee Onboarding and Offboarding: Simplify the onboarding and offboarding processes for new and departing employees, ensuring a seamless transition. 3. LLM-Ba...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Exce...
**Project Description:** We are in search of a creative and professional freelancer to design a one-page product catalogue that showcases our 12 distinct collections of bedsheets and diwan sets. This catalogue will serve as a key marketing tool, highlighting the unique designs and quality of our products to prospective clients and distributors. **Project Objectives:** - **Design and Layout:** Develop a visually appealing one-page layout that features each of the 12 collections effectively, ensuring the design aligns with our brand aesthetics. - **Content Presentation:** Strategically place images, product details, and pricing information to maximize readability and visual impact. - **Brand Alignment:** Adhere to our existing brand guidelines, including the use of specific f...
tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...
I have four pic...pictures of my parents that I would like to merge into a single photo frame design. The final design should be in black and white with a thin frame. The frame size should be 11 inches in height and 14 inches in width, and the photos should fade into the background from the shoulder upwards. Ideal skills and experience for this project include: - Graphic Design: Experience in creating custom photo frames is essential. - Photo Editing: Proficiency in black and white photo editing and blending photos seamlessly. - Understanding of visual composition and aesthetics. - Ability to work with specific dimensions and design requirements. Please submit your portfolio of similar projects if available. Looking forward to working with a talented and creative individual on...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
Seeking a skilled and experienced developer to execute an AI-based Android app meant to perform tasks such as image classification and face recognition. An integral requirement for this role is proficiency in the integration of JNI C++ libraries. The foundations of the project include: - Development of an app compatible with Android phones - Integration and enhancement of machine learning algorithms into the app - The app must process object detection & tracking tasks using machine learning The ideal candidate should have: - Prior experience in Android app development - Strong knowledge of machine learning - Proficiency in the integration of JNI C++ libraries Integral to success in this project is a developer's ability to balance technical machine-learning objectives ...
I need a proficient Matlab Simulink professional to simulate the current production in a semi-truck's solid oxide fuel cell. This should take into account multiple variables, specifically: - Temperature - Pressure - Fuel flow rate These should be varied at high levels in the simulation. With a requirement for medium precision, the model should sufficiently represent the real-world scenario without too much granularity. The goal is to understand how these variables affect the current production. The ideal candidate should have a strong background in thermodynamics, system simulations, and Matlab Simulink. Experience in solid oxide fuel cells and vehicular simulations would be a significant advantage.
New freelancers from Pakistan and India. I need some Coders of Python, Asp.net for some easy tasks I need work for long term I need a serious and hard working persons
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the resp...
