Excel filter by list of namesงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
" K ฺBeauty by Eroom Consultant " โอกาสดีๆ สำหรับหญิงไทย (อายุระหว่าง 20-59 ปี) ที่มีใจรักการดูแลสุขภาพผิวหน้า...กับ " การรับสมัครกลุ่มตัวอย่างเพื่อเข้าทดสอบตรวจสุขภาพผิวหน้าโดยทีมงานมืออาชีพบินตรงจากประเทศเกาหลีใต้ " เพื่อนำผลการตรวจสุขภาพผิวหน้าหญิงไทยไปพัฒนาผลิตภันฑ์ในแบรนด์เครื่องสำอางค์ของเกาหลี (ใช้เวลาในการตรวจประมาณ 1 ชั่วโมงเท่านั้น) สามารถสมัครเข้าร่วมการทดสอบได้ตั้งแต่วันที่ 13 พฤษภาคม 2565 เป็นต้นไป - รับทั้งหมด 770 คน - (คุณสมบัติของผู้ที่จะเข้าร่วมงานสามารถอ่านรายละเอียดได้ในรูปถัดไป) สิ่งที่ผู้ได้รับการตรวจสุขภาพผิวหน้าจะได้รับ ดังนี้ - ของขวัญสุดพิเศษ นำเข้าจากประเทศเกาหลี 100% - ผลการทดสอบสุขภาพผิวหน้า (ผู้เข้าทดสอบจะได้รับผลการทดสอบหลังจากทำการทดสอบ 15-20 วัน โดยจะแจ้งผลทางไป E-mail ) เริ่มทดสอบตั้งแต่วันที่ 20 มิถุนายน 2565 - 30 กรกฎาคม 25...
...สามารถ 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
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.
...Photo Grouping: Create a system for organizing photos into groups and folders. Preview and Search: Implement image preview and search/filter options for quick access and management. Customization: Allow for easy customization of colors, layout, and other elements. Submission Guidelines Design Files: Submit HTML, CSS, and JS files. Demo Link: Provide a link to a live demo of your template. or a pic if you want Documentation: Include basic documentation on how to use and customize the template. Evaluation Criteria Design Aesthetics: Clean, modern, and visually appealing design. Usability: Intuitive and user-friendly interface. Functionality: Implementation of required features and overall functionality. Responsiveness: Seamless performance across different dev...
...1. Name of the event is 'Poly Networking Event' 2. The event will be held on July 20, 2024. 3. The event will host guest speakers from IT & Engineering professionals from fortune 500 companies such as Adobe, NASA, Micron, Raytheon, Carrier, and many more. 4. There will be fun activities, dinner, drinks, memorabilia giveaway. Ideal Candidate: - Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this s...
I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and c...
...visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by wh...
I'm in need of a skilled automation specialist to help me streamline and optimize a multi-step process that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be fully automated. Additional Details: - The daily list of patie...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I need someone to find the names of prospects using a provided lead list. Here's what the task involves: Finding Names: Use sources such as Google Reviews, company websites, Facebook pages, and other relevant platforms to find the names of prospects. Methodology: If you have any: we'll discuss and agree on the methods you’ll use to search for the names. IMPORTANT: Simplicity and Critical Thinking: The process should be straightforward, but critical thinking is crucial. Feel free to ask questions early on to clarify any doubts—no stupid questions. Timing: I will give you a list of 20 leads. Track how long it takes to find the names from start to finish, which should be between 5-13 minutes per ...
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I'm seeking an animator skilled in producing traditional frame by frame 2D animation, to create a 30-second animation clip for my LoFi channel, with japanese anime aesthetics. The animation needs to be 30 seconds long, and it's part of a series of videos, so, it's a long term project. Ideal Skills and Experience: - Extensive experience with traditional 2D animation (Toon Boom, Procreate Dreams, etc) - Prior experience in creating short animation clips - Strong creativity and artistic skills References: Lofi Girl: My sketch:
...database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
...responsible for keeping track of both pricing and product availability. A high level of accuracy is essential. Update frequency should be configurable. This script should be written in an efficient language. As I have no specific preference, I trust your judgement on choosing a language that is effective for the required task. Ideal requirements: - Proven experience in developing similar scripts - Knowledge of and experience with eCommerce website structures - Accurate and detail-oriented developers are highly essestial. Your proposal should include the language you intend to use and why you think it would be the most suitable. Please also mention how frequently the script will update the information. Start your bid with "Tracker Guru" to help me ...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
...- Prior experience with the Ultimate POS script - Proficiency in Laravel Livewire - Strong understanding of accounting principles The Ledger Report: - The ledger report should have a user-friendly interface and should be able to filter transactions based on specific criteria. - Transactions should be classified as either debit or credit, which should be reflected in the report. Deliverables: - A functional ledger report integrated into the Ultimate POS script with the ability to classify transactions as either debit or credit. - A clear and well-organized codebase that allows for any future modifications to be easily implemented. It's important to emphasize that the classification of debit and credit transactions in the ledger report should be carefully disc...
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
...need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all i...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm in need of a tool that, provided a list of words or phrases, the tool can comprehensively check the availability of those words or phrases across various online platforms. It is primarily aimed at checking the availability of domain names, phone numbers, trademarks, and social media handles. Additionally, it should search for the mentions of the given words or phrases in Google organic search and various shopping sites. Note that some of these sites may not have APIs available to perform these checks. Ideal Skills and Experience: - Proficient in Web Development: The tool needs to be designed to perform these checks on multiple platforms in a seamless and efficient way. - Familiar with SEO and E-commerce: The ability to accu...
I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can crea...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of da...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate...
...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your ex...
