Countifs function in excel with multiple criteria jobs

...urgently require a talented and experienced Figma designer with strong proficiency in React.js to update the design and content of our financial services website. The successful candidate will be responsible for revamping existing static pages to make them live, responsive, and dynamic. This role demands immediate availability and the ability to deliver high-quality work within a tight deadline. Responsibilities: Revamp Existing Website Interface Quickly analyze and update the current design and content of the static pages. Ensure new designs are modern, user-friendly, and engaging. Efficiently translate Figma designs into functional React.js components. Design and Update Sections Redesign the following sections, ensuring compatibility with React.js: Home About U...

...clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed -...

We are seeking an experienced PHP developer to assist in fixing existing and add new back-end functionality. Our platform allows parents to book their children's lunch boxes for selected schools, offering multiple choices for the boxes. Parents can select the school and timings through dropdown menus. We receive the details on our dashboard and print stickers to be pasted on the boxes. Currently, we are facing issues with obtaining accurate order details, leading to mismanagement and manual intervention. We also want to integrate a monthly subscription feature for parents. The ideal candidate should have a strong understanding of PHP and be able to create clean, efficient, and scalable code. As a PHP Developer, you will be responsible for implementing new featur...

1. Create a chatbot. 2. Use an open-source LLM. 3. Use an iterative method to get a very large response. 4. Add a button in the chatbot. When enabled, it can show responses from public sources; otherwise, it must show results from a private source, such as a Pinecone database. Additionally, there should be a page where I can upload my text and PDF files. The response will be displayed like ChatGPT, with a typewriter effect & tell me more ..follow up response multiple time

I'm in need of a skilled programmer to create an automation code page for me. This code page will be focused on text processing, so a strong understanding of working with textual data is essential. Key Requirements: - Proficient in JavaScript: The automation code should be written in JavaScript to ensure compatibility with other platforms. - Automation Experience: The primary function of this code will be automating tasks. A proven track record in building automated processes is highly desirable. - Text Processing: The code must be able to accurately and efficiently process textual data. Experience in this field will be a huge advantage. If you have experience in JavaScript, a background in automation, and a stro...

...developer to create a Telegram bot with natural language processing capabilities that can generate PowerPoint presentation files (.ppt). The bot will guide users through a series of steps to create a fully customized presentation. The ideal candidate should have experience in bot development, PowerPoint automation, and natural language processing. Key Requirements: - The bot should be compatible with both the Telegram mobile app and web version. - It should primarily focus on generating slides based on provided text inputs. Ideal Skills/Experience: - Proficiency in natural language processing - Extensive experience in building Telegram bots - Proven track record in developing AI for image retrieval - Previous work on user interaction...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

...includes corporate users who may also have an individual account. Prizes: 1 x $500 USD top prize for one profile 2 x $200 USD to the runners up 5 x $100 USD for honorable mentions Details, Terms and Conditions Your new profile will use your existing cover photo, profile image and profile description - make sure you update your cover photo image as the cover photo aspect ratio has changed. Criteria: Creativity (33%) How creative is the design and content of the profile? Would clients be able to differentiate this profile from others? Aesthetics (33%) How aesthetically pleasing is the profile? Would clients like to look at the profile? Content (33%) Is the content on the profile high quality and informative? Would clients read the content on the profile? Jenis ...

I'm in need of a talented developer or team who can create a comprehensive platform across website, Android and iOS. Here's what I'm looking for: - **Primary Purpose**: The main focus of this project is to build a multi-functional platform that combines e-commerce, service booking, buying and selling, health tracking, social connectivity, and event ticketing. The service will be given in Asia Pacific, Europe, the Middle East and North America. This means you should have experience in developing diverse features and managing complex systems. - **Payment Integration**: I need to integrate credit/debit card and PayPal payment methods. Experience with secure and reliable payment gateway integration is crucial, so please include relevant examples of ...

I'm looking for an artist skilled in painting to instruct at a workshop tailored for adults aged 18-50. The ideal candidate should meet the following criteria: - Proficiency in painting techniques suitable for an intermediate-level audience. - Effectiveness in teaching adults, with a knack for clear and understandable guidance. - Prior experience hosting or teaching painting workshops is highly beneficial. Let's add color and creativity to the lives of aspiring adult artists.

...help me transfer an application from my old Windows server to a new one. The server is currently running on Windows OS and the application is built with Visual FoxPro 9 and ASP.NET Key Requirements: - Proficiency in Windows server management and application migration. - Experience with Visual FoxPro 9 and knowledge of its compatibility requirements. The new server must have the following installed: - ASP.NET Framework 3.0 or higher - Visual FoxPro 9 - Office 2019 Please make sure to include in your proposal any related experience and specific skills that make you a suitable candidate for this project. Project Description I'm currently in a bit of a tight spot. A Windows Server 2016 web application () was recently moved from a US provider to...

...a computer science graduate who is proficient in Python, specially trained in Chatgpt, to build a web-based AI application for my business. I need the application to be specialized in natural language processing and sentiment analysis, and subsequently serve as a recommender system to provide information and answer queries. Key Features: - Natural Language Processing: The system should be capable of comprehending textual data, extract relevant details and produce appropriate outcomes. - Sentiment Analysis: Enable the detection and understanding of sentiments within the processed text. - Recommender System: The goal is to provide customized information based on the user's interests or preferences. - Information Provider: The AI should function as chatbot...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...track record in designing and executing successful B2B email marketing strategies and will be able to provide evidence of past performance. Responsibilities: - Develop and execute a comprehensive cold email campaign strategy using Mailchimp. - Craft compelling email content and subject lines designed to capture the attention of potential business clients. - Segment and manage the email list to ensure maximum engagement and response rates. - Monitor and analyse campaign performance, providing regular reports on key metrics such as open rates, click-through rates, and conversion rates. - Optimise the campaign based on performance data to achieve the best possible results. - Ensure compliance with all email marketing regulations and best practices. Requirements: - Proven ex...

I need a virtual assistant well-versed in social media management. Your task will revolve around these selected platforms: Facebook, Instagram, Twitter, and Tumblr. Job responsibilities include: • Posting on social and doing RT on Twitter a day across all selected platforms. • Engaging with followers consistently to foster interaction and growth of the community. Ideal Skills and Experience: • Proven experience in managing multiple social media platforms. • Excellent communication skills for effective engagement with followers. Preference will be given to those with a keen understanding of effective social media strategies and an ability to maintain a consistent and appropriate brand voice.

...impact of sleep quality on cognitive function and its measurement, - Understanding of focus and flow state from a neuroscience-based perspective, proven techniques to improve focus and remaining in flow state, measurement - A cohesive analysis of mental resilience, its impact on cognitive function, proven techniques to improve mental resilience and measurement. Your responsibilities will include: - Conducting a comprehensive literature review on the topic, - Identifying the clinically proven strategies and practices to improve sleep quality, focus and mental resilience with the associated metrics - Producing a cogent white paper suitable for peer review. Ideal bidders should hold relevant experience in neuroscience, ideally with a s...

I have a project that involves Excel data entry and maintaining an incentive structure. - The Excel data entry tasks require specific formatting and formulas. You should be comfortable working with these. - The incentive structure is not overly complex but does have multiple tiers and criteria that need to be accurately maintained. Ideal candidates for this project should have: - Proficiency in Excel, including experience with data entry and the use of formulas. - An understanding of incentive structures, ideally with experience in maintaining them. - Attention to detail, as accuracy is key. - Good communication skills, in case clarification is needed. I will send the file in chat

Please Sign Up or Login to see details.

I require an efficient programmer equipped with the crucial skills in Pine Editor coding. The project involves designing a script based on the 'Trading View' platform to automate my stock market trading strategy. The strategy revolves around Multiple EMA (Exponential Moving Average) crossing. For this specific task, a system with three different EMA lines is preferred. Ideal Skills & Experience: - In-depth knowledge of Pine Editor; - Familiarity with Trading View platform; - A fine understanding of EMA and its implementation in trading strategies; - Previous track record demonstrating similar tasks completed. I emphasize clarity and efficiency in the script to enhance my trading decisions. Please, get in tou...

I need a WordPress expert to set up a membership-based website with varying levels of access. Key Requirements: - Programming the website according to the membership flow I have in mind. - Implementing multiple tiers of membership. Skills Needed: - Proficiency in WordPress, especially with membership plugins. - Experience in setting up and managing different levels of membership. - Good understanding of user registration and login processes. Please note that there are additional features I may need in the future, so a flexible approach and willingness to accommodate future requests is appreciated.

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditio...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I'm urgently seeking a skilled individual with experience in data entry. The main tasks include completing online form filling and helping me decipher an image. Key Responsibilities: - Online Form Filling: The job involves handling online form completions. The forms are fairly straightforward and shouldn't be overly complex. - Image Deciphering: You'll be required to assist me with interpreting an image. The complexity level is not specified, but it's anticipated to be moderate and should be manageable for an experienced professional. Key Requirements: - Proficiency in data entry, particularly in the domain of online form filling. - Strong attention to detail is crucial, as the correctness of the entries is paramount. - Experience ...

I'm starting a new baby product brand and need a logo for my business. I'm looking for a modern, minimalistic design in pastel colors Key Requirements: - The logo should be suitable for a baby brand, which means it should be playful and appealing to parents. - The design should be modern and minimalistic, avoiding overly complex elements. - Pastel colors are preferred for the logo, helping to convey a sense of calmness and serenity. Ideal Skills and Experience: - Proven experience in designing logos, especially for baby brands or similar consumer-focused industries. - Proficiency in modern, minimalistic design, with a good understanding of color psychology. - Experience in creating designs that are both playful and professional, suitable for a...

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm seeking an expert to elevate my visual content across multiple platforms. I'm directly targeting business professionals. Key Details: - Photo editing: Enhance and retouch images. - Graphic design: Create compelling visuals. Intended Use: - Social media: Impactful posts to attract and engage. - Website: Professional look reflecting our brand standards. - Print: High-quality materials for events and promotions. Ideal Freelancer Skills: - Proficient in Adobe Photoshop. - Strong portfolio in photo editing and graphic design. - Experience creating for a corporate audience. - Keen eye for design trends suited for business professionals. - Ability to work with tight deadlines and maintain quality. I value creativity, punctuality, and effective communi...

I am in search of a skilled Photoshop expert for a project involving photo editing of 35 images of my hotel real estate. These images are intended for optimizing my Airbnb listings. Images - Key Editing Requirements: - Removing background: Ensuring that the focus is solely on the property by removing any unnecessary elements. - Enhancing colors and lighting: Making the images visually appealing through color adjustments and lighting enhancements. - Image Sharpening: Emphasizing on the sharpness and details of the images. - Lens correction: Correcting any lens-related distortions to ensure the pictures are accurate. - Image Resizing and Formatting: Preparing the edited photos in the appropriate dimensions

Seeking Talented Mobile App and Website Developer Are you a skilled freelance developer with expertise in crafting seamless experiences across mobile and web platforms? We're seeking a talented individual to collaborate with us on an exciting project to develop a modern and user-friendly job search platform. Key Functionalities: - User Registration and Profile Management: Enable users to create, manage, and update their profiles to streamline the job search process. - Real-Time Messaging: Facilitate communication between job seekers and employers through real-time messaging functionality. - Advanced Search and Filtering: Empower users to discover relevant job listings based on specific criteria such as location, industry, and job type. - Subscription-Bas...

...sleek and contemporary logos that resonate with the modern audience. Please pay attention to the latest design trends in the market. - The logo should be versatile, easily scalable, and work well in both digital and print formats. - I particularly like the modern and clean aesthetics of brands like Apple and Nike. I envision my logo to have that kind of simplicity and impact. " Instabyte Enterprises logo should look like laptop power button icon " I & B should be clearly visible. logo should match the essence of laptop power button. Ideal Skills and Experience: - Proven experience in logo design, especially in creating modern and minimalist logos. - Strong knowledge of brand identity and design principles. - Familiarity with de...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm in need of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will b...

Tengo un error en codeigner con la api de mikrotik , necesito hacer funcionar este script corrigiendo este error: }catch(Exception $e){ return $e->getMessage(); } } } } // Mikrotik API if (!function_exists('mkClient')) { function mkClient() { return new PEAR2NetRouterOSClient(settings()[0]->mkipadd, settings()[0]->mkuser, settings()[0]->mkpassword); } } // Mikrotik API Util if (!function_exists('mkUtil')) { function mkUtil() { return new PEAR2NetRouterOSUtil(mkClient()); } } Class 'PEAR2NetRouterOSUtil' not found

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing ...obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you ...

I need a developer or team who can implement a multi-login feature on , allowing users to log in from multiple accounts simultaneously. The aim of this feature is to facilitate user management by enabling users to control multiple accounts at the same time. Key Responsibilities: - Integrate simultaneous multi-login feature on - Ensure the feature is user-friendly and stable - Thoroughly test the feature to ensure it's functioning as intended Successful applicants should have: - Proven experience with web development, particularly in implementing login systems - A strong understanding of user management principles - A portfolio showcasing past work, particularly similar projects - The ability to work independently and efficiently to meet project de...

...Features: * Object Detection and Text Extraction AI Capabilities - Uses advanced AI algorithms to detect and interpret various elements within the slab plans. * Supports Multiple Formats - Must be able to process JPEG and PDF formats. * Comprehensive Detail Analysis - Capability to identify and count specific components such as void formers, reinforcement bars, and structural beams. Ideal Skills and Experience: * Extensive experience in AI Development, specifically in the fields of Object Detection and Text Extraction * Demonstrable experience in creating software that can process and interpret renderered images in multiple formats * Prior experience or understanding of construction plan analysis would be a significant advantage. Example slab ...

I am in need of a skilled and experienced architect to create a unique and functional design for a sizeable commercial campus covering more than 10 acres. The ideal person for this project should have: - Proficiency in the latest architectural design software - Experience in commercial campus design or large-scale commercial projects - A portfolio showcasing innovative designs - A deep understanding of the efficient use of large spaces - Ability to deliver projects promptly Your main task will be creating a comprehensive architectural blueprint for this vast commercial campus. I look forward to working with a creative mind that can integrate function and aesthetics impressively.

..."Adelya Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the name "Adelya" with the name "Tecmark" Step 6: There should be 12 replacements, then you know you have done it right Step 7: Save the file once again as "Tecmark Expansion - Australia and New Zealand" Step 8: Save a second copy of the file in PDF version (Powerpoint will offer you an option called "Save as file type"...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions f...

Please Sign Up or Login to see details.

..."Adelya Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the name "Adelya" with the name "Tecmark" Step 6: There should be 12 replacements, then you know you have done it right Step 7: Save the file once again as "Tecmark Expansion - Australia and New Zealand" Step 8: Save a second copy of the file in PDF version (Powerpoint will offer you an option called "Save as file type"...

My requirements for this project are straightforward: Preferred Technologies: - Expertise in HTML/CSS, JavaScript, and React is necessary. Project Goal: - The focus is to create one responsive landing page while ensuring it's user-friendly. The site needs to be easy to navigate catering to all devices, desktop through mobile. Target Audience: - The website is designed for business professionals. Hence, the interface should resonate with professional aesthetics, smooth user experience, and functionalities. Looking forward to collaborating with a dedicated professional who understands the above criteria. Your portfolio demonstrating previous work with similar requirement will be beneficial.

I'm seeking a skilled designer to develop a unique and aesthetically pleasing menu holder for restaurant use. This project will require you to create a design concept, craft a prototype, and ultima...will include: - Designing a unique and stylish menu holder suitable for a restaurant setting. - Crafting a prototype based on the initial design. - Producing a set of sample units that will allow us to test function and feasibility. Ideally, you have experience in the following areas: - Product Design - Prototype Development - Experience with restaurant-related products is a plus Your creativity, attention to detail and ability to meet deadlines will be key to the success of this project. If you have relevant past experiences or portfolio pieces, pleas...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

...designs will be used in an upcoming promotional material that will be sent for print. Key Project Requirements: - Transform 11-20 employee photos into cartoonish caricatures - Ensure the caricatures are of high-resolution quality - No background for the caricatures is needed although provide: - Clean head shot (face only) - Body standing straight - Body with their arm out as if they are presenting or revealing something (see sample in attached documents) Sample photos of raw images you will be working (converting) with a sample of style we like although we are open to other ideas. Ideal skills and experience for the job: - Proficient in caricature design - Strong illustration skills or using AI - Experience in creating high-resolution image...

I'm looking for an Electrical Engineer who is experienced with Raycus Laser systems and its associated components such as Raytools BM110 Auto Focus, Raytools Software, and leadshine servo drives. The main role involves configuring these elements to integrate seamlessly. Key Requirements: - Proficiency in configuring Raycus Laser hardware, Raytools BM110 Auto Focus, Raytools Software, and leadshine servo drives. - Experience with CNC Gantry Function Software. The ideal freelancer should: - Have demonstrated experience in machinery and software configuration. - Be located near Reno, NV for potential onsite work. - Prioritize accuracy in their work, as ensuring the correct configuration is my primary focus.

I need a Python developer to create a bot that scrapes data from APIs on an hourly basis. - The bot's primary function is to scrape data - The data will be sourced from APIs - The bot needs to run on an hourly basis Ideal candidate: - Proficient in Python and API data scraping - Familiarity with creating bots - Able to ensure smooth hourly operation, possibly using a scheduling library such as APScheduler

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...