Advanced filter excelงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Im looking to have a Solana ping bot with the ability to detect and attempt to filter out potential scams based on machine learning software. Ensuring that daily 10-100x calls are made effectively. Key Requirements: - AI & Machine Learning Proficiency: The ideal candidate will be well-versed in AI and machine learning technologies, able to design a bot that can learn and adapt to new scamming tactics. - Solana Ecosystem Expertise: Strong understanding of Solana and its projects is crucial to successfully identify potential scams. - Telegram Integration: The bot should be designed to work seamlessly within the Telegram app. I'm looking for an active developer who can work alongside me in this exciting new venture. Please get in touch for further discussions.
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
Hey there! We're searching for a talented developer to help us convert an existing HTML/CSS/JS project into Builder.IO. If you're experienced with and have a knack for turning static projects into dynamic, user-friendly websites, we want to hear from you! You'll be taking our current HTML/CSS/JS project and transforming it into a custom website, ensuring it's responsive and looks fantastic on all devices. You'll also collaborate with our design and content team to create a seamless and visually appealing experience. We're looking for someone with proven experience in , strong skills in HTML, CSS, and JavaScript, and a passion for creating beautiful, functional websites. pls answer my questions on your proposal. Do you have experience translating HTML/CSS/J...
... highlighting key criteria used to assess supplier reliability. - Any additional insights or recommendations based on the sourcing agent's expertise and industry knowledge. Requirements: - Proven experience as a product sourcing agent in China, with a strong track record of successfully identifying and vetting suppliers. - Expertise in navigating and platforms, including advanced search techniques and supplier verification methods. - Excellent communication skills and proficiency in English and Mandarin to effectively interact with suppliers and provide accurate information. - Attention to detail and accuracy in providing supplier information and pricing quotes. - Ability to deliver results within the specified timeframe and adhere to project requirements and guidelines
I require a professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes f...specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - Proficiency in Microsoft Word, including advanced knowledge of style and formatting tools. - Strong attention to detail and ability to work ef...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking a mobile app developer with experience in developing TV app...specifically focus on TV content. This includes channels that cater to TV shows, documentaries, or other related TV broadcasts. - **Device Compatibility**: The app should be compatible with Samsung and LG smart TVs. The ability to ensure the app runs smoothly across different models of these brands is crucial. Ideal candidates should have: - Proven experience in developing TV applications - Advanced knowledge of live streaming protocols and technologies - Familiarity with the Samsung and LG smart TV platforms - Strong problem-solving and debugging skills - Excellent communication and teamwork skills, as continuous coordination with me is vital. Please provide samples of previous TV app development wo...
I'm seeking a professional with expertise in sound and vibration analysis to assist me with various tasks in this area. The specifics are as follows: - The tasks will include both noise and vibration analysis. - You'll be required to utilize advanced analytical techniques to solve problems related to sound and vibration. Ideal candidates should have: - Proven experience in Sound and vibration analysis. - Strong knowledge of analytical techniques and tools within this field. - Excellent problem-solving skills and the ability to work This is a great opportunity to work with a client who values expertise and professionalism in sound and vibration analysis. one day deadline
Help add search filter to iOS Swift App that exposes the selected items in the array (selected indexes) and the selected index if only 1 is returned.
I am looking for a professional photographer with experience in real estate and vacation rental property photography. The Photo Shoot Will Include: - Vacation rental properties showcasing interior design elements, property exterior, and landscaping. - Capturing local attractions or amenities related to the properties. Ideal Skills For This Job: - Advanced skills in real estate photography, with a significant focus on vacation rentals. - Ability to capture and highlight interior design elements and property exteriors. - Proficiency in photographing local attractions or amenities. - A keen eye for detail to ensure the properties are presented in an appealing way. Candidates are desired to provide a portfolio of similar work done in the past. Experience in public relations wou...
I'm on the lookout for an experienced video editor with superior skills in advanced editing techniques including color correction, special effects, and audio enhancement. The project comprises editing a video of a duration exceeding 10 minutes. Skills Required: - Expertise in advanced video editing techniques - Proficiency in color correction - Special effects implementation - Audio enhancement abilities Please note, a storyboard or script isn't provided, allowing you full creative control to bring the footage to life. Applications from individuals with a knack for creativity are particularly welcomed. Your portfolio demonstrating your past work would be advantageous during the selection process.
...Scraping Specialist to optimize and significantly increase the speed of our current data scraping processes. The ideal candidate will have extensive experience in web scraping, advanced knowledge of bypassing anti-scraping measures, and proficiency in utilizing cloud-based solutions for enhanced performance. Strong problem-solving and hacking skills to navigate complex web security systems are essential for this role. Responsibilities: Analyze and improve existing data scraping scripts to maximize efficiency and speed. Implement and manage cloud-based solutions (AWS, GCP, Azure, etc.) for scalable scraping tasks. Develop advanced strategies to bypass anti-scraping measures like CAPTCHAs, rate limiting, and IP blocking. Ensure data scraping processes comply with legal and...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualizati...
...teacher who specializes in both Java and Python. I'm seeking advanced-level guidance, mainly through the following: - One-on-one mentoring: You will provide personalized, in-depth insights catered to my capacities, skills, and learning speed. We will explore challenges and complex concepts together. Patience and exceptional communication are crucial. - Expertise in Java and Python: You must demonstrate a solid understanding and practical application of these languages in the industry. Exit profiles such as the development of complex systems, application in advanced artificial intelligence, or extensive backend management would be ideal. - Advanced Level Programming: I need a tutor who can help me comprehend and implement advanced aspects of programm...
I'm actively seeking virtual assistants proficient in using advanced software tools, including cloud storage and project management software. Essential tasks that need to be managed are: - Data entry: Accurate and efficient data input is required, particularly into project management software. - Email and calendar management: Duties include organizing my inbox, prioritizing emails, and managing my schedule. I anticipate requiring support for more than 20 hours a week. As such, freelancers should be available to commit to a significant amount of time. Ideal candidates will have a proven track record in similar roles and excellent references.
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I'm in need of a skilled developer or team that can design and build a highly specialized mobile platform. The platform should be able to adapt to various unique applications. This platform should be intuitive, user-friendly, and able to support a range of features. Key Features: - Natural Language Processing: The platform should possess advanced natural language processing capabilities. - Voice Chat: The ability for the platform to support voice-based communication. - Image and Multimedia: The platform should support a range of multimedia options, from text to photo uploads. Platform Support: The mobile application should support the interface and experience similar to that of Pi from Inflection AI or ChatGPT from OpenAI. Design: The design should be sleek and modern, cate...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I'm seeking an experienced Advanced GMAT tutor to help me excel in the exam. I've chosen to study online, so please ensure you're comfortable with this format. Key Requirements: - Expertise in Advanced GMAT: I'm at an advanced level and I need a tutor who can help me elevate my skills to the next level. - Comprehensive Coverage: I need support in all areas of the GMAT including Quantitative section, Verbal section, Integrated Reasoning, and Essay. - Online Teaching Skills: As I'll be doing all my learning online, you must be adept at teaching through this medium. Ideal Skills and Experience: - Proven track record in GMAT tutoring, especially with advanced students - Strong understanding and grasp of all sections of the GMAT - Ex...
I'm looking for a skilled Photoshop artist to professionally enhance a photo by adjusting the colors and lighting. Key Tasks: - make the sea blue/turquoise in the attached photo Ideal Skills: - Advanced color-correction skills in Photoshop - Proven record of achieving natural-looking, flattering results in lighting adjustment - Deep understanding of visual focus in a photo and ability to subtly shift it to a chosen object or person.
I'm in search of a proficient freelancer who has expertise in utilizing MATLAB R2021a for complex Image Processing tasks. As my requirements are quite specific, it is crucial that the preferred candidate has in-depth knowledge of this software and can make the most of its advanced features. Key Responsibilities: - Conduct comprehensive Image Processing tasks - Utilize MATLAB R2021a to its full potential Ideal Skills and Experience: - Profound understanding of MATLAB R2021a - Significant experience in Image Processing - High problem-solving skills using MATLAB Given the specificity and technical nature of this job, candidates who can showcase samples of their previous work with MATLAB, specifically in Image Processing, will be prioritized. This is an opportunity for s...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST API...
I'm search...estate photographer, specializing in shooting residential homes, commercial properties, and vacation rentals. You will be responsible for capturing the true essence of these properties through both basic and advanced techniques like HDR photography and video tours. Key areas of focus include: - The facade and outdoor spaces, capturing their uniqueness and charm - Specific rooms like the kitchen and the living room, showcasing their functionality and ambiance Preferred Skills and Experience: - Proven experience in real estate photography (will train) - Proficiency in both basic and advanced photography techniques - Keen eye for architectural details - Ability to capture and highlight key property features. - Must have DSLR camera and wide angle lens -Dro...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of th...
...identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to various audience segments. Set up and manage multiple ad campaigns across Google Ads (Search, Display, YouTube) and Facebook Ads (Feed, Stories, Audience Network). Utilize advanced targeting techniques, including demographic, behavioral, and geographic targeting. Optimization and Analysis: Monitor and analyze campaign performance data to identify trends and insights. Perform A/B testing to continually refine ad copy, creatives, and targeting strategies. Optimize campaigns to maximize ROI, reduce cost per lead (CPL), and achieve the highest possible lea...
