Excel count how many times a value appears in a columnงาน
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...
dice detection use c++ opencv count point for each dice object same this project https://www.freelancer.com/projects/opencv/Dice-Image-Number-detector-OpenCV/details
ทำ 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)
(Translated in Google↓) เรากำลังมองหานักเขียนสื่อเว็บเกี่ยวกับการท่องเที่ยวไทยในญี่ปุ่น * เพราะฉันต้องการให้คุณเขียนเป็นภาษาไทยฉันจะ จำกัด เฉพาะคนไทยหรือผู้ที่สามารถเขียนบทความเป็นภาษาไทยใกล้เคียงกับเจ้าของภาษา [สรุป] - สื่อ: สื่อทางเว็บเกี่ยวกับการท่องเที่ยวญี่ปุ่น - บทความจากบทความ: ประสบการณ์การเดินทางไปญี่ปุ่นจากรายงาน Bangkok-Travel (เช่นรายงานการเดินทางบน ) - ตัวละคร: ประมาณ 1,000 คำต่อบทความ (ภาษาไทย) - จำนวนบทความ: 3 ถึง 5 ทั้งหมด (หนึ่งภาพก็เป็นไปได้) - ภาพ: โปรดใส่รูปภาพการเดินทางจริง ๆ ที่ถ่ายด้วยตัวเอง . - ตัวอย่างชื่อบทความ:“ ไดอารี่ 7 วันแรกของการเดินทางไปโตเกียว”“ ฉันไปฤดูหนาวที่ฮอกไกโดและเทศกาลหิมะซัปโปโร” ฯลฯ [วิธีการเขียน] ไดอารี่การเดินทางไปญี่ปุ่นที่ฉันมีประสบการณ์ด้วยตัวเอง - โปรดเขียนประสบการณ์ ===================================...
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
Thai native speaker is a must! We need you translate from your comprehension and put emotion in it as it’s the reading. There are totally 78 cards, please quote your best leadtime (or how many cards you can accept), best price and give 5-sentence translation of below for an example. 1##เทพแห่งความสำราญ##THE FOOL##คนโสด ที่ไขว่คว้าหาความรัก กล้า ๆ หน่อย อย่ามัวลังเลรีรอ แสดงความรู้สึกให้คนที่แอบรัก แอบชอบ ได้เห็นอย่างชัดเจน โอกาสมารออยู่ตรงหน้าแล้ว คนมีคู่ รักคนที่มีเจ้าของแล้ว หรือถูกหลอกลวง เพื่อหวังผลประโยชน์นอกจากเจ็บปวดที่ใจ แต่ก็อาจเจ็บตัวได้เช่นกัน##คุณมีอารมณ์เบื่องานเป็นอย่างมาก โดยเฉพาะหากคุณต้องทำงานแบบเดิมๆ อยู่ทุกวัน ก็จะยิ่งทำให้อยากจะหาความท้าทายอะไรใหม่ๆ ให้กับชีวิตการทำงานของตัวคุณเอง##ควรระวังโรคภัยไข้เจ็บที่เกิดจากการเดินทาง เช่น ภูมิแ...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
...an expert in the domain flipping business to help me sell a small collection of domains that I own. Key Responsibilities: - Evaluate and determine the market value of each domain - Create compelling listings for each domain, highlighting their potential value and target buyers - Promote the domains across appropriate platforms to maximize visibility - Handle negotiations with potential buyers and finalize domain sales Ideal Skills and Experience: - Proficiency in domain flipping or a related field - Strong understanding of the domain market and what makes a domain valuable - Excellent written communication skills for creating persuasive listings - Experience with online sales platforms and negotiating sales - Proven track record of sel...
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
Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.
I have a logo concept that I need help with. It's a vertical chain of letters, linked with a connecting feature (arrow). Key Requirements: - Enhance and align the letter chain effect and connecting arrow - Clean up stray pixels and prepare it for higher resolutions After the design adjustments, I need the final logo delivered in 18 different formats: - JPEG, PNG, and GIF - Black background, white background, and clear / no background - one medium resolution (modest file size for easy web browsing) and one high resolution (max 4 MB) file size Your advice on appropriate image and file sizes will be of value; I am not an expert in this matter. Your work will ensure that the logo is versatile, visually appealing, and ready to be used across v...
I'm in need of an experienced social media manager who can handle my Facebook, Instagram, and Youtube accounts. Key Responsibilities: - Your primary task will involve posting engaging content 2-3 times a week on all three platforms. - You'll be responsible for creating and sharing compelling and creative image and video-based content. Ideal Candidate: - Proven experience in managing social media accounts. - Proficient in creating engaging and visually appealing images and videos. - Strong understanding of the social media landscape and trends. - Excellent communication and time-management skills.
...Aesthetics: Implement a clean, contemporary design that aligns with current web design trends. 3. Enhanced User Experience: Ensure the page is intuitive and user-friendly, with a focus on seamless interaction. 4. Mobile Responsiveness: Optimize the design for mobile devices to cater to our growing mobile user base. 5. Fast Load Times: Improve page load speed to enhance user satisfaction and SEO performance. 6. Effective Call-to-Actions (CTAs): Strategically place CTAs to drive conversions and engage visitors effectively. 7. Visual Appeal: Use high-quality images, videos, and graphics to make the homepage visually appealing. Features to Include: • Easy access to our latest products/services • Customer testimonials or reviews to build trust • Clear con...
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 c...
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.
... Font loading issue At the moment I have a font loading issue with several different fonts being loaded before the final one is loaded. I need one font instantly loaded rather than how it appears currently. I’m happy for this to be a different font (such as one that sits on Google), if it will load instantly, however I want the font still looking good, Lead Form capture not working The form capture isn’t working correctly. Originally it was sending through to my email address when someone filled out a form, however I had my email moved from GoDaddy to Google and it hasn’t worked since. Additionally the form capture doesn’t have the capability to actually see the responses within WordPress. I am happy to change to a...
I need a dedicated LinkedIn Specialist to refine and manage our company's LinkedIn presence. Responsibilities: - Post three times a week, maintaining a consistent and engaging schedule - Connect with HR professionals and key decision-makers, aiming to cultivate a strong network - Engage with content to enhance visibility - Track analytics to measure and improve our LinkedIn performance Your primary goal will be to nurture professional relationships within our industry. This role will require a strategic approach to networking, utilizing engaging content to foster connections. The content you'll be focusing on is mainly company updates and achievements. You must translate our successes and milestones into compelling, shareable posts th...
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 ...
I'm looking for a skilled developer to create a Defi similar to Dextool/Dexscreener. The project will require a comprehensive understanding of cryptocurrency markets, and the ability to create a robust tracking and information system. Ideal skills and experience for this project include: - Proficiency with real-time data integration - Extensive experience with cryptocurrency-related projects - Strong analytical and problem-solving skills - Familiarity with blockchain technologies - The ability to design and develop user-friendly interfaces I need a clone of Dexscreener for the BASE chain. a. We need to pull data from various AMMs like UniSwap, base swap, Alien Base, PCS b. Display those data in our design which is pretty much sim...
I'm looking for a talented and experienced analyst to help me evaluate a public company in the energy sector. The insights gathered will be essential for strategic decision making. Your primary task will be to conduct a comprehensive analysis of the company's financial performance, market position, sustainability practices, enterprises value, and strategy. Your analysis should provide thorough insights into these areas, helping us understand the company's strengths, weaknesses, opportunities, and threats. Key requirements: - Evaluating Financial Performance: I need a detailed analysis of the company's revenue, profitability, cash flow, and debt levels. Your insights here will be crucial in understanding the company'...
I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to include analytics to track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM a...
...Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a third image....
...on beauty. These articles would need to be 1000 words each. The ideal candidate should have experience in writing content for beauty-related topics. The main task of this project will be to get these articles published on 70 different guest posting websites. All of these websites should have a domain authority of 50+ with DoFollow backlinks for SEO purposes. You would need to manage the entire publication process from pitching the articles to the website owners to getting them to publish it. It's essential that the articles not only provide value to the reader but also subtly promote our brand and products. The goal is to drive traffic to our website and increase our online presence in the beauty industry. Publish 70 articles on 70 guest posting websi...
...looking for a person with knowledge in German Health & Safety regulations. Native German speaker and good command in English or Spanish is needed in order to be able to obtain the training and coordinate with our validation team. The job will consist on checking documentation to see if the validation requirements established for each documents are met. Our client needs to obtain certain documents from the companies that are going to work in the premises of our client. The documents will be related to the company, employees, tools and vehicles. The task is to validate or not the document. In case there is a non compliance, then the person will need to request the ammended document to the subcontractor. This is a remote job...
...google lighthouse to generate an SEO Audit report. Here is a link to how you can do it. Here is an example how these people have integrated and using google lighthouse to generate reports. We need exactly the same. 2, need an admin panel where admin can add or import the list of the website url,and website owner name , number and email address. So report can generated by the system and keep sending the email pdf report to the owner of the website like its work in front side for this site 3, We need to save PDF reports in the same column of every website so we can resend the report to the website
I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past 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 Go...
I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from 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 ...
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. - ...
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.
...am looking for a second one. A plus if you can do video editing or graphic design. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that...
I'm seeking a skilled web designer to improve an existing visually engaging, informational website for a general audience (mostly big companies and legal companies worldwide) It will primarily host text and image content. Ideal candidate should: - Have a rich portfolio of visually diverse websites - Have strong expertise in designing image-focused sites - Understand best practices to cater the design for a general public - Be detail oriented, and able to optimize images for quick loading times and responsive design. The existing website that i want to improve is
I own a logo right now and I require someone to augment it by adding the word 'Podcast'. Alongside that, I want to explore different color schemes for this updated logo. Specifically, I'm interested in vibrant colors that will infuse energy into the brand. Here's what I would value in a freelancer: - Proficiency in graphic design with a portfolio highlighting logo enhancement. - An innate understanding of how colors impact a brand's perception and performance. - An ability to translate words into visually compelling designs. Ultimately, I'm looking for someone who can add value to my existing logo, turning it into a colored, catchy design that attracts my podcast's targeted...
I'm in the process of establishing a new digital marketing agency and need a website that will effectively bring in leads for potential clients. Key Details: - The primary goal of the website is to generate leads, which means it must have a strong emphasis on user engagement and conversion. - Our target audience is primarily small to mid-sized companies, so the design and content should be tailored to resonate with these groups. - The website should have a professional and appealing design that conveys our expertise and offerings in a clear manner. - While I'm open to suggestions and would appreciate your input, I'd like to have a contact form integrated into the website, as I believe this will be a cruc...