Excel count condition jobs

I need an Excel professional to help me clean up my data. Specifically, I'm looking for someone who can assist with text and number formatting. Key tasks include, but are not limited to: - Data cleanup, focusing on text and number formatting - Ensuring the data is well-structured for its intended use - Delivering the formatted data in a different file format than the original Excel file Ideal candidates should have: - Proficiency in Excel and its various functions - Prior experience in data cleanup and formatting - Attention to detail and commitment to quality - Strong communication skills, as you may need to clarify certain aspects of the data. Please deliver the formatted data in a different file format, which will be provided by me.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

Hello, I need complet the Amazon categories catalogue excel in french

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.

...- Air-Shipping Time Duration: We’re looking for air-shipping time duration between 1-14 days. - Final Destinations: To make sure the shipping company can deliver the product from China till our clients doorsteps in GCC countries. - Efficient Handling Of Electronics & Clothes: You should be well-versed in handling electronic goods and clothes to ensure they reach their destination in optimal condition. - In-Depth Knowledge Of GCC Customs Regulations: You should be familiar with the customs regulations of Saudi Arabia, United Arab Emirates, Bahrain, Oman, Qatar, and Kuwait to ensure the smooth passage of the shipments. Ideal Candidate: - Proven experience in logistics and shipping, particularly with air freight. - A strong network in the logistics industry to secure ...

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.

I have my kids channel which i want to grow in terms of views and subscribers. Key Requirements: Most Important- Increase in Views and Subscribers: I'm looking for a professional who can help boost my channel's visibility and subscriber count. Other optional - Content Strategy: I also need assistance in devising a plan to optimize my videos for increased visibility. - Target Audience Engagement: The content is mainly geared towards children, so the freelancer should keep that in mind when suggesting strategies. Ideal Skills and Experience: - Proven track record in increasing YouTube views and subscribers. - Previous experience with kid's content and understanding of engagement strategies. - A creative approach to promoting YouTube channels to a broad audience.

I’m currently sitting below 50 followers with an Instagram page focused on Art and Creativity. My main challenges are: - Boosting followers count - Improving post engagement The ideal assistant should have: - Proven experience in Instagram growth, especially for art-themed accounts - Proficient knowledge in Instagram's algorithms & engagement patterns - Capable of crafting strategies that can propel followers count and enhance post interactions In brief: Aim to develop a gainful footing in the Instagram Art circle featuring outstanding post engagement and a substantial increase in followership. Apply if you have a tested track record in delivering these outcomes.

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 conditional formatting and ot...

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 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 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.

...your time and consideration. I look forward to your response and any guidance you can offer. - Campaign Purpose: I chose GoFundMe as a platform to raise vital funds and prevent potential homelessness, which shows the urgency and gravity of the situation. - Fundraising Goal: My aim is to raise a target amount of $10,000. These funds will make a significant impact in providing a stable living condition and necessary support. - Audience: This cause isn't restricted to just friends, family, or a local community. It's a dire circumstance that could arise for any individual, making it relevant to a global audience. Ideal candidates for this project should: - Have an experience in social media promotions or fundraising campaigns. - Understand the sensitivities of the situa...

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 construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...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 excel at this, you might be the right fit ...

...website that can provide comprehensive takeoffs from uploaded residential and commercial slab plans. Key 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 con...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...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 using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

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 for accurate and efficient data arrangement. - Potential...

As a TikTok Influencer Outreach Specialist, your main task will be to connect with influencers/KOLs on TikTok within the United States. Key Responsibilities: - Reach out to TikTok influencers with a follower count of over 5K - Encourage the influencers to accept a free premium product sample - Request the influencers to create video content around the said product Your role is pivotal in ensuring the success of our TikTok influencer promotion campaign. Ideal Skills and Experience: - Proven experience in influencer outreach on TikTok - Familiarity with the United States market and TikTok trends - Exceptional communication skills - Ability to close deals with influencers - Knowledge of how to negotiate and motivate influencers to create content Please note that w...

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!

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.

As a lifestyle content creator, my main focus is to increase the number of subscribers on my YouTube channel. Key Requirements: - Goal: The primary aim is to develop a strategy to organically increase the channel’s subscriber count. - Skill: You are expected to have experience in growing YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with your detailed proposal. I'm looking f...

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.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

I have 6 photos that require fine editing. I have a (hopefully) temporary condition called Bell’s Palsy. This unfortunately came up right before graduation and has made my graduation photos something I am not excited to share. I need editing to make my face resemble its former state, of which I will attach a picture. Specifically, I need an expert with: - Proficiency in color correction and retouching. - Skills in facial structure manipulation, particularly in modifying eye shape, mouth shape, and ensuring symmetry on both sides of the face. This is a delicate and artistic task requiring precision in the reshaping of features without compromising the natural feel. Therefore, prior experience with such projects would be ideal. There is potential for additional pictures ne...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

I'm in urgent need of a writer with a solid understanding of nursing. Please place your bid if you are capable of starting immediately. Ideal Skills & Experience: - Strong background in nursing - Ability to work with academic references - Quick turnaround time Please note that I've skipped specifying the word count and references for now. If we proceed further, we can discuss these details.

I'm in need of a simple Android application th...the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot) Post condition static weight text - If the weight is equal to the previous logged weight (or if it is the first weight), give it an orange background color (see screenshot) - If the weight is lower than the previous logged weight, give it a green background color (see screenshot) Additional requirement - Android API level 34 - github rep...

...popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+ Authentication is done through twitter, I will connect my twitter account and run the script

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

Create a tradingview script that: Show a candle from green >red>green and vice versa but the condition that second candele cannot close lower or higher than prior third candele cannot close under previous open.

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

...tactics - Sports-specific drills to enhance your on-field performance - **Friday: Gym Work** - Strength and conditioning tailored to athletes - Improve endurance, speed, and agility 3. **Key Skills and Knowledge Gained** (Use attractive icons and short impactful phrases): - **Goal Setting:** Learn how to set realistic, measurable, and impactful goals. - **Peak Physical Condition:** Custom exercises to make you fitter, faster, and stronger. - **Mental Toughness:** Cultivate a winner's mindset to overcome challenges. - **Sports Specific Expertise:** Train with drills tailored to enhance football performance. - **Personal Development:** Track and measure progress, adjusting strategies to maximize effectiveness. 4. **Pricing and Call to Action:...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

Start your offer with the word in the att...Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 hours of starting our...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I am in need of a skilled animator to create a 3D promotional animation for my locker product. The target audience for this video is adults, so the animation should be informative and visually appealing to a mature audience. Key requirements and responsibilities include: - Creating a 3D animation styled video - Crafting the video with ...changes into green and he can take out his bed again Maybe we have a different light at this time because it’s afternoon or evening He leaves and the door closes automatically because of the self closing hinges. Contest: The video should not be longer than seven seconds, and in the next step we will add all the administrative functions on the video as well. But that is another object Please count with some small changes included aft...

I'm in need of a talented designer to craft a classic and elegant booklet for my project. Here are the specifics: - Size: A4 (8.3 x 11.7 inches) - Page Count: 20 to 50 pages The design should reflect a timeless and sophisticated aesthetic, incorporating classic elements while still appearing fresh. I want the design to be simple and uncluttered, evoking a sense of refinement and simplicity. Ideal Skills: - Proficiency in graphic design software (e.g., Adobe InDesign, Illustrator) - Strong understanding of classic design principles - Experience in booklet design - Ability to create engaging layouts for a multi-page document. Please include samples of your previous work in a similar style when applying. Your design will be critical in ensuring my booklet is both informative ...

...and Authentication: • Users can sign up using their email or social media accounts. • User accounts store personal information, trip history, and preferences. Operator Registration and Authentication: • Coach operators can register and provide details about their services, pricing, preferred locations, etc. User Dashboard: • Users can submit trip details including location, and passenger count. • Users receive quotes from multiple operators. • Users can view and manage their trip requests, quotes, bookings, and messages. • Chat functionality to communicate with operators. Operator Dashboard: • Operators can view available trip requests. • Operators can send quotes to users. • Operators can manage their accepted bookin...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English