How to merge two excel sheets based on one column vlookupงาน
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 ที่กำหนดให้
Please key Thai characters on PDF into word are the past question and answers of exam and total sheets has around 200 letters.
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
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...
Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.
I'm searching for an experienced Laravel developer to construct a site in two stages. This stands as a Software as a Service (SaaS) project designed to aid with product uploads onto e-commerce and marketplace platforms. Site will need to be built in Laravel using the blade framework and tailwind. It will include integrations with and I have provided a fill project outline so please ensure that it is read before bidding as i need the costing in 2 parts. The cost for stage 1 and cost for stage 2 as we would like an MVP of the product first. Please ensure that your bid has the cost of both parts but in the description include the split between both parts and the hourly rate.
...integration to build the checkout system of our bulk ice selling business' website. Key tasks include: 1. **Payment Gateway Integration**- The checkout system should incorporate a payment gateway to facilitate secure transactions. 2. **Delivery Address Input** - Allowing customers to input their delivery address to ensure proper and accurate delivery of our products. 3. **Order Confirmation Email** - After a successful purchase, an order confirmation email should be sent to customers for their records. 4. **Design** - Implement a simple and clean design that aligns with the website's current aesthetic. 5. **Delivery Tracking** - Incorporate real-time tracking of deliveries into our system to enhance customer experience. Ideal c...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont e...
...skilled developer to create a group 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 Ski...
...comprehensive CMS platform for handling loan data. Key Functionalities: - User Management: The CMS should have the ability to manage users, with a specific focus on admins. - Reporting and Analytics: The system should incorporate robust reporting and analytics features that can offer insights into loan applications and user activity. - Application Rejection: There should be a clear mechanism for rejecting loan applications within the system. - Filters will be required to filter and sort data as per date, status, month. User Roles: - Admin: The primary user role I'm seeking is for admins to manage the system. Rejected Applications: - The system already have a mechanism in place to handle rejected loan applications. Ideal Skills: - Experience wi...
...Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic 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 completio...
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.
...opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The Grant Writer will identify, define and develop funding sources to support existing and planned program activities as well as lead the development, writing, and submission of grant pro...
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 fl...
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 o...
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.
... 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 advantageous. Th...
I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.
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.
...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 ...
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 fre...
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 c...
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.
...an 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 se...
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 u...
...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 fonts, colors, and...
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 creat...
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 ...
