Excel unique combinations two columnsงาน
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
I'm looking for a talented tattoo artist who can bring to life a realistic depiction of a scene from the video game Bloodborne. This is meant for an arm tattoo. Key Requirements: - Familiarity with or willingness to understan...inspired by the Gehrman Moon beheading scene with the same quality and detail as the second image(the image was created by AI). I'd like the image to be of him holding his scythe above his head as depicted in the execution scene, but as close and with the same perspective as the AI image The design must capture the essence and atmosphere of the game, demonstrating a clear understanding of its unique style. Interested artists must provide their portfolio or relevant design samples. Your creativity in sketching a cohesive design will be valued in m...
I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
...product knowledge of our intermediate level sales staff. Key Elements: - Interactive Design: The presentation should be engaging and interactive, enhancing the learning experience by incorporating quizzes, scenarios, and other interactive elements. - Product Knowledge: The main aim of this training is to ensure our sales team has a deep understanding of our products, their features, advantages, and unique selling points. - Target Audience: The presentation should be tailored to intermediate level sales staff. It should provide valuable insights and knowledge that can be easily applied in a real-world sales environment. Ideal Skills: - Proficiency in Instructional Design: You should have a solid understanding of instructional design principles and methodologies. - Sales Trainin...
I'm looking for a talented logo designer to work with me on creating a unique, eye-catching logo for my company. Key Elements and Colors: - I've attached detailed information about my company and the key symbols or elements that should be included in the logo. This will help you understand what my business is about and what I want to convey through my logo. - I've also included information on the colors I'd like to see in the logo. You'll find a mix of colors that I think are representative of the brand's values and personality. Skills and Experience: - Proven experience in logo design, with a strong portfolio of work that demonstrates your skills in creating unique, memorable logos. - Ability to interpret a brief and translate it into a creat...
...minimalist. The colour palettes should be neutral, earthy, with an eye-catching and clean font. Key Project Requirements: - Draft unique, minimalistic designs that capture the essence of my brand - Incorporate creative input and suggestions to enhance initial ideas - including a logomark which can be neatly printed on basic capsule pieces like tees - Reflect a sense of originality and creativity in the final design Ideal Skills and Experience: - Proficiency in graphic design tools - Strong portfolio in logo and logomark designs, especially with minimalistic style - Experience working with fashion brands is desirable but not mandatory. The final result should be a unique, recognizable, and minimalistic logo that embodies the creative spirit of my clothing line. I am look...
...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 customization. - Strong background in user management and access control systems. - Previous...
I'm in need of a professional designer for an upcoming housewarming event. I envision a unique blend of modern and traditional aesthetics for the invitation card to mirror the style of my new home. Key responsibilities: - Creating a modern-traditional themed design. - Incorporating house details into the invitation. Ideal Candidate: - Versatile designer with proficiency in both modern and traditional designs. - Experience creating detailed and personalised event invitations. - Prior experience with housewarming invitation cards is a plus.
I'm in need of a fresh, illustrative logo ...for a mix of black and white, blue and white, and green and white. - The selected freelancer will need to have a good understanding of the market and should be able to deliver a design that stands out in the industry. - Experience with logo design for established businesses is a plus. Please provide samples of your previous work that showcase your skills in this area. - The design should be unique, modern, and memorable. - The selected freelancer will need to be responsive to feedback and able to make revisions if required. - Timely delivery of the project is crucial. The the person is a Doctor For the following Psychology - psychotherapy - mental health - weight management - eating disorder - obesity - weight loss - h...
I'm embarking on a project that requires a professional web developer to create a raffle website. This website will offer unique features and functions essential for the raffle operation. Exactly Like Key Functionalities: - Ticket Purchasing: A seamless and user-friendly ticket purchasing system is crucial. The website should facilitate both user registration and guest checkout. - Random Selection of Winners: A secure and unbiased method of randomly selecting winners must be incorporated. - Notification to Winners: The website must notify winners in a timely and efficient manner. Types of Raffles: - Weekly Raffles: The system should support the conducting of weekly raffles. - Special Event Raffles: Furthermore, the website should be able to host special event raffles. Ideal
I'm seeking a seasoned furniture designer to create modern furniture models for multiple rooms in my newly constructed home. Specifically, the project involves designing furniture for the five bedrooms, foyer, living room, dining room, en...room, dining room, entertainment room and one lounge Ideal Skills and Experience: - Previous experience with furniture design. - Strong knowledge of contemporary, modern styles. - Familiarity with designing furniture for bedrooms, living rooms, and dining rooms. Project Goals: - Ultra Luxury furniture design required - To create unique, practical, and modern furniture designs for a bedroom, living room, and dining room. - To have preliminary sketches within two weeks. Please, include a portfolio of past projects. Looking forward...
...functionalities of the app. iOS: Capture 10 high-quality screenshots for each device size: iPhone 6.7" iPhone 6.5" iPhone 5.5" iPad 13" iPad 12.9" Screenshots must be taken directly from each device; resizing from other screenshots is not acceptable. Ensure all screenshots comply with the guidelines of both Google Play and the Apple App Store. Screenshots should highlight the main features and unique selling points of the app. Videos: Android: Record 2 demonstration videos showcasing the app's functionalities, each between 30 seconds to 1 minute long. iOS: Record 3 demonstration videos for each device size (iPhone and iPad), each between 30 seconds to 1 minute long. Total of 15 videos (3 for each iPhone size: 6.7", 6.5", 5.5" and 3 fo...
I am looking for someone who can create a frontend website (no need admin) looking like reference website (see URL below). Your creation must be unique, but we need a fancy looking GUI and animations. You can pick your own animations and elements. Reference site: Less then 1000 Euro? DM and we can make a deal. More then 100 Euro? Please do not bid.
As I'm setting up an NDIS company focused on providing disability support services, I'm in need of a seasoned business plan writer who can help me craft a solid foundation for my business. Key Concerns: - Market Analysis and Positioning: I'm looking for someone who can delve deep into the market, identify our target audience, and pinpoint our unique selling points. - Financial Planning and Projections: I need an expert who can create a detailed financial plan that reflects our current financial situation, and provides projections for growth. - Operational Structure and Processes: The ideal candidate will be able to help me create a sustainable operational structure that ensures smooth running of the business. Target Market: I'm looking to cater to a wide range...
...this project, the main focus will be on creating a fun and colorful logo that will set me apart from the competition. Key Requirements: - The logo should be fun and colorful, appealing to a wide audience. - It should be unique and creative, reflecting the innovative nature of my new business. - I'm seeking a design that can be easily recognized and remembered. Ideal Skills and Experience: - Proven experience in designing logos, especially those incorporating fun and colorful elements. - A strong portfolio showcasing creativity, originality, and the ability to produce unique designs that align with brand identity. - Strong communication skills to understand and translate my vision for the logo into a tangible design. I'm looking for a talented and experienced...
I need an expert to retrieve a missing Excel document from my Windows configured laptop. This document has been missing since February 2024, and I have no backup available. The document was created using an unknown version of Excel, so the freelancer would need to check the specifics during the recovery process. Key requirements: - Recover the missing Excel document which was lost for unknown reasons - No backup available - The document was created using an unknown version of Excel Skills and experience needed: - Proficient in data recovery - Experience in retrieving files from Windows systems - Familiarity with different versions of Microsoft Excel Can pay 12 usd
A global tour agency is looking to hire experienced and knowledgeable guides for private tours in Jeonju, Gangneung, Jeju City, and Seogwipo, South Korea. Ideal candidates should: - Be well-versed in the local history, culture, and outdoor attractions of the mentioned cities. - Have a friendly, engaging, and professional deme...attractions of the mentioned cities. - Have a friendly, engaging, and professional demeanor. - Have excellent communication skills in English. Korean language proficiency is a plus. The agency is seeking to hire 8 guides, with varying skill sets and tour guiding experiences to cater to the different types of tours being offered. If you have a passion for sharing your knowledge of South Korea and its unique offerings with international visitors, please get...
I'm seeking an experienced 3D CAD designer for my jewelry business. The project will specifically involve creating a contemporary, modern design for engagement rings. Key Requirements: - Expertise in 3D CAD design, particularly pertaining to jewelry creation - Strong understanding of modern ring design trends - An inventive approach towards gemstone set...trends - An inventive approach towards gemstone setting - Realistic renders - (optional: 3D videos animations of the rings (visual merchandising, setting, display, etc) to create advertisings of my future brand) Freelancers with a related portfolio, focusing on ring designs, will be given priority. It would be beneficial if your application includes previous work samples. The goal is to create a unique, modern ring design t...
I'm looking for a professional with proven experience in improving both physical infrastructure and performance of a broadband internet system. My non-profit organization needs: • Faster internet speeds • Increased bandwidth • Enhanced stability and reliability Improvements in physical infrastructure ...speeds • Increased bandwidth • Enhanced stability and reliability Improvements in physical infrastructure will entail: • Upgrading network cables • Installing new routers and switches • Expanding our coverage area The ideal consultant should have notable experience in network optimization, cabling, and hardware installation and configuration. A successful bid will show an understanding of the unique needs of non-profit organization...
...incorporating player silhouettes. Rather than a realistic representation, the design should focus on abstract interpretations that capture the essence of the sport. Ideal Skills and Experience: - Graphic Design: A strong portfolio of previous design work, particularly in sports-related imagery, will be highly beneficial. - Creative Thinking: The ability to think outside the box and come up with a unique and eye-catching concept. - Communication: The designer should be open to feedback and able to translate ideas into a visual concept. Please note that the choice of colors is open-ended, giving you creative freedom to propose an appealing color palette that complements the other design elements. Your design will be a core representation of our team, so attention to detail and or...
...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
...a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and up...
I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
...come up with "Would You Rather" jokes for a middle school audience. The jokes should: - Be suitable for middle school students. - Be delivered in written form, without the need for illustrations or audio. - not IA generated - not from internet or from existing books (sorry, we already have them all) Ideal candidates for this project are: - Experienced writers or joke creators who understand the unique sense of humor of middle schoolers. - Able to produce engaging and fun content that is suitable for kids/family party. - Creative and able to come up with a wide range of jokes on different everyday topics. Your work will help entertain and engage our young listeners and must respect the target audience's age and sensibilities. We can discuss for a prize for ---...
I'm looking for a talented abstract artist based IN BELGIUM or FRANCE, !!! to create a unique pen and ink traditional hand made drawing for me ( fits inside A4). the concept is on the photos more explanation done via dm's Key Requirements: - You must be based in Belgium, as I prefer to receive the final drawing via post. - Proficient in pen and ink drawings (hand drawn, traditional), with a strong portfolio in the abstract style. - Should have a deep understanding of fantasy themes, with a particular focus on 'Lord of the Rings'. If you think you have the skills and creativity to bring this vision to life, please don't hesitate to apply. Thank you. deadline: one week from the date posted of this project.
As a creator of wood and epoxy furniture and an aspiring YouTuber I require an experienced Shopify website developer who can create a platform for my products. The website should include a product catalogue and testimonials. Key tasks: - Develop a dynamic and visually appealing Shopify store. - Incorporate a user-friendly product catalogue system. - Integrate a testimonials section. The successful candidate does not need to worry about generating product descriptions or snapping exquisite product images; I will provide all necessary content. However, they should be able to present this content in the most engaging manner possible on the platform. Also I have a crappy site hosted by Wordpress already and would like to take that domain name over to Spotify if possible. I would also like...
...minimalistic logo for my Ecommerce Store, Play Zone 24 (We sell toys on online shop). I'm open to your creativity regarding the color scheme - as long as the logo looks good, I'm happy. Key Requirements: - Modern and Minimalistic Design: The logo should be sleek, simple, and contemporary. - Professional and Polished: It represents a company, so it should look professional. - Creativity: I'm looking for a unique and original design, not something generic or overused. Your Skills: - Experience in Graphic Design: Proven experience in logo design, preferably with a modern and minimalistic style. - Creativity and Originality: A distinct style that sets you apart from other designers. Please submit your portfolio along with your proposal. Looking forward to seeing...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm in need of a freelancer who can create a realistic profile picture for my gaming platform account. The profile picture should be: - Realistic: I'm looking for a design that captures a lifelike quality. - Original: I don't want the design to be based on a photo I provide. I'm looking for a unique and creative concept. - Gaming Platform Ready: The design should be tailored for use on a gaming platform. Ideal skills and experience for this job include: - Strong illustration skills with examples of realistic designs in your portfolio. - Ability to come up with original and creative concepts. - Understanding of design requirements for a gaming platform, such as size and format. Looking forward to seeing your proposals!
