How to find duplicate values in different excel sheetsงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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 ที่กำหนดให้
Please key Thai characters on PDF into word are the past question and answers of exam and total sheets has around 200 letters.
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm seeking an experienced accountant to help with financial reporting and tax preparation for my Puerto Rico-based nonprofit organization. Your tasks will include creating balance sheets, income statements, and cash flow statements. Ideal Skills and Experience: - Proficient in Wave accounting software - Experienced in nonprofit accounting - Skilled in creating comprehensive financial reports - Knowledgeable in tax preparation for nonprofits
...upskilling and internship program to showcase successful alumni. These videos will be used primarily on social media platforms to engage young adults aged 23-30 in India. The scripts will be provided to you. The project is urgent and needs to be finished by 7th Feb 2025. Key Requirements: - Professional & Engaging: Capture a relaxed but formal style that reflects the program's atmosphere. - High-Quality Production: Ensure professional video production and editing with a focus on social media engagement. - Script Adherence: Work within provided scripts while maintaining a natural and authentic feel. - You need to find people to shoot such videos. Ideal Candidate: - Experienced Videographer: Proven experience in pro...
I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!
I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)
I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included
I'm in need of a seasoned lead generation professional who can tap into LinkedIn to find potential buyers for my real estate projects. Key Responsibilities: - Targeting local property buyers through LinkedIn - Utilizing LinkedIn Ads as the primary tool for lead generation Ideal Skills and Experience: - Proven track record in lead generation, particularly in real estate - Proficiency in managing and strategizing LinkedIn Ads - Strong understanding of local real estate market - Excellent communication and networking skills
...seeking a dedicated individual or a team to assist with research into Melbourne-based businesses. Your primary tasks will include subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales...
I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.
I am seeking a team to construct a train for the Montreal metro, The MPM-10 also knowned as the Azur. Ideal Skills and Experience: - Expertise in designing and building trains. - Experience in passenger transport train construction. IMPORTANT I only want a specific part of the train the front part you can find in the pictures
I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED
I need an expert WordPress developer to help me use an existing investor's website as a template. My current site is a generic Carrot website, which I want to discontinue. I have a GoDaddy domain name that needs to be redirected to the new site. Key tasks: - Duplicate the layout and design of the selected site - Mimic the content structure (with my own text and contact info) - Redirect my existing domain to the new site - Ensure a smooth transition from my old site to the new one Ideally, you have: - Proven experience with WordPress - A strong understanding of real estate investor website elements - Excellent skills in web design and layout replication - Familiarity with GoDaddy domain management I want to use the inv...
I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail
...Project Overview: Teach KC is a groundbreaking collaborative initiative launched by BLAQUE KC, aimed at transforming the education system in Kansas City. By uniting diverse organizations, educators, policymakers, and community leaders, Teach KC seeks to create sustainable change that positively impacts students, educators, and families. The initiative embodies a spirit of collaboration, innovation, and empowerment, with a focus on fostering equity and excellence in education. Objective: The objective is to design a distinctive and impactful logo for Teach KC that visually represents the initiative’s mission and values. The logo should reflect Teach KC’s commitment to educational equity, collaboration, and community empowerment, whil...
I am looking for a talented Python developer to create an application that will run on a Raspberry Pi. This application will process the RTSP stream from an IP camera to find and read a digital weight display. Key Features: - The weight display is fixed in position, so the application will not need to track moving elements on the screen. - The application should perform Optical Character Recognition (OCR) on the display and store the results in a text file. - The whole system needs to function without any internet access. Web Interface: - A web page hosted on the Raspberry Pi will be used for testing and adjusting parameters. This includes tweaking OCR settings and viewing logs. - The application should also allow me to start and s...
...goal for this project is to market to customers. Key Aspects to Include: - Company history: This should detail our journey, milestones, and evolution in the industry. It needs to be engaging and reflect our growth and achievements. - Mission statement: This should succinctly convey our purpose and what we strive to achieve. - Company vision: This should illustrate our long-term aspirations and where we see ourselves in the future. - Core values: These should reflect our fundamental beliefs and guiding principles. - Why we: This should be a compelling narrative that explains why customers should choose us over our competitors. Ideal candidates for this project should have exceptional writing skills, with a knack for creating pers...
Necesito un/a programador/a para crear una plataforma con IA que pueda analizar datos de un archivo de Excel, la plataforma deberá ser capaz de buscar información especifica según ciertos criterios como rangos de precios o características particulares, además se busca que la plataforma deberá aprender de los datos para encontrar patrones y sugerir combinaciones relevantes. Si estas interesado/a escríbeme y podremos conversar más sobre el proyecto.
I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experie...
I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visuali...
I need my website to be redesigned with a primary focus on increasing user engagement. Key Aspects: - I don't have specific websites to draw inspiration from, but I have a general idea of what I find engaging. A freelancer who can understand and translate these ideas into interactive features would be ideal. - I value content quality, so a background in creating or managing blogs and videos could be beneficial. - User experience is crucial. I need the navigation and load times to be optimal to keep users on the site. Skills and Experience: - Web design and development with a focus on user engagement - Experience in creating interactive features - Content management skills - Strong understanding of user experience design - Ability ...
...uk/ Objective: To scrape and extract all relevant data from the above website for internal use. The extracted data must be well-organised, accurate, and easy to navigate for future reference. (Wordpress based but do not want to use the WP plugin) Scope of Work: 1. Data to Scrape: • Product details (e.g., product names, descriptions, specifications, features, images, pricing, and PDFs, if available). • Blogs and articles (titles, content, and associated metadata such as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images an...
...talented Front-End Developer to join our busy Development team. You will be instrumental in creating mobile-optimised, user-friendly web applications and delivering high-quality solutions to meet client needs. If you’re ready to make an impact with a company that values innovation and quality, we’d love to hear from you. Key Responsibilities: Collaborate with back-end developers and UI/UX designers to implement and optimise user interfaces. Designing and developing complex web applications using modern technologies and frameworks such as Ionic, React.JS, TypeScript and Next.JS. Experience in building mobile-optimised front-ends for websites. Exposure to mobile development using Ionic, React Native or ...
...talented Front-End Developer to join our busy Development team. You will be instrumental in creating mobile-optimised, user-friendly web applications and delivering high-quality solutions to meet client needs. If you’re ready to make an impact with a company that values innovation and quality, we’d love to hear from you. Key Responsibilities: Collaborate with back-end developers and UI/UX designers to implement and optimise user interfaces. Designing and developing complex web applications using modern technologies and frameworks such as Ionic, React.JS, TypeScript and Next.JS. Experience in building mobile-optimised front-ends for websites. Exposure to mobile development using Ionic, React Native or ...
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
...web developer to create a traditional and elegant matrimonial website. The site should have: - User Profiles and Matching: Users should be able to create profiles and the system should facilitate matching based on user inputs. - Search and Filter Options: A robust search and filtering system for users to find potential matches based on their preferences. - Image Filtering: The system should be capable of filtering uploaded images and removing any inappropriate content. Furthermore, I would like the user registration process to incorporate social media integration. This will allow for a more seamless and user-friendly registration experience. Ideal candidates for this project should have: - Proven experience in web development and creating sim...
I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.
...creating a Google Sheets calendar roadmap that will require integration with Google Calendar (Tasks) for a user based on their unique calendar ID. This resource will allow stores to easily build, implement, and track a marketing plan in preparation of their Grand Opening. Elements we’re looking to have built out include the following: Calendar Generation: A store will input their expected Grand Opening date and a Google calendar will be created using the entered date and the selected areas of marketing. Each area of marketing includes recommended start dates that will be populated on the calendar. Calendar Subaccounts: We’ll have one umbrella account that the corporate team has access to. Each generated calendar will be created as a subac...
I'm looking for a skilled developer who can integrate the Square API with a Google Sheets dashboard to display real-time sales data. Key deliverables: - Pull sales data from the Square API - Update the Google Sheets dashboard in real-time - Track specific metrics: Total sales amount and Number of transactions Ideal candidates should have: - Experience with API integrations - Proficiency in Google Sheets - Understanding of sales metrics - Ability to ensure real-time data updating.