Excel display rows based on criteria jobs

I'm seeking a skilled data entry specialist to assist with removing duplicates from spreadsheets comprising various datasets. The primary goal of this task is to ensure that our data is clean and free of any redundant information. The spreadsheets will be provided for you to analyze and clean accordingly. Ideal c...of any redundant information. The spreadsheets will be provided for you to analyze and clean accordingly. Ideal candidate must have: - Proven experience in data entry, particularly data cleaning and deduplication. - Proficiency in working with spreadsheets. - Attention to detail and high level of accuracy. - Ability to understand and follow provided data cleaning guidelines. If you fit the criteria and are ready to undertake this task, I look forward to seeing...

I'm seeking a qualified web designer to update my website's layout. Here's what I need: - Introduction of a Media Page: This page should display links and articles, creating a repository of press and online publications about my company. - Adjustment of Existing Sections: We'll need to discuss which parts of the site can remain as they are and which ones need alteration to accommodate the media content. Practical experience with web layout changes is a must, and knowledge of content organization is highly advantageous. Anticipate a job revolving around comprehension of detail and alignment with my company's visual branding. Take note that while changes are significant, preserving the overall feel of our original page is paramount. I'm looking forward ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

Looking for a video editor who is proficient at editing on DaVinci Resolve both in terms of color grading as well as working with black magic raw files. You need to be confident in your video editing skills, I will need short engaging social media videos up to 2 minutes long, with added elements like pop-up photos, graphics, subtitles, and subtle sound design. Tasteful and professional. Some projects will include creating engaging social media clips from prerecorded video podcasts. Event summary edits and other dialogue-focused videos. Talking head videos, and b-roll edits. (all footage will be provided) You must be detailed oriented and fluent in English, it is important that there are no typos! This job requires excellent communication and quick turnaround times! I am looking ...

I'm in need of a financial programmer with experience in Easy Language (TradeStation) to create an automated trading strategy for the stock market. The strategy will be designed to make trading decisions autonomously, based on specific criteria. Key Requirements: - Proficient in Easy Language (TradeStation) - Demonstrated experience in creating automated strategies for the stock market - Ability to understand and implement complex trading algorithms Ideally, the project should be completed within a week. I am looking for a professional who can effectively communicate and ensure the successful execution of this project.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I need an expert that can help change a date on a paper receipt. I have a picture of the receipt and need someone to change the date on it. The deadline is tight, so I need this done ASAP. Ideal candidate should: - Have experience working with physical documents - Demonstrate strong attention to detail - Be able to complete the task quickly and efficiently.

...login functionalities. - Payment Processing: The system should be able to process donations securely and efficiently. Project Types: - Charitable Projects: Users will be able to create projects aimed at raising funds for charitable causes. Donation Display: - List of Donors with Amounts: I want donors to be recognized for their generosity with their donation amounts displayed. - Anonymous Donations Option: Donors should have the option to remain anonymous if they prefer. - Total Amount Raised Only: The main project page should prominently display the total amount raised so far. Ideal Skills: - Strong experience in crowdfunding platform development, particularly for charitable projects. - Proficiency in secure payment processing integration. - UI/UX design skills to ensu...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I'm seeking an experienced researcher to investigate retail displays in Wuhan, China. The project will specifically focus on Talens, a famous art supply brand. The research aims to provide insights into the following aspects: - Brands Available in Displays: The core of this project is to identify and analyze the presence and positioning of Talens within the retail space. - Competitor Analysis: While the primary focus is on Talens, it will be valuable to understand how other brands like Nike, Adidas, and Apple are being displayed in the retail outlets. - Customer Behavior: I'm particularly interested in how the retail displays are shaping customer behavior and purchase decisions. Ideal candidates should have a background in visual merchandising, market resea...

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...

...portfolio, so it needs to be visually appealing, easy to navigate, and optimized for lead generation. Key Deliverables: - A home page that grabs the visitor's attention and encourages them to explore further. - An 'About Us' page that introduces our team and explains our company's mission and values. - A 'Services' page that clearly outlines the IT solutions we offer. - A 'Portfolio' page to display past projects we've successfully delivered. - A 'Testimonials' page to showcase feedback from our satisfied clients. The ideal candidate should be experienced in: - Web design, preferably with experience in creating websites for IT companies or tech startups. - UI/UX design, ensuring the site is user-friendly and intuitive. - S...

...details of this project are: - Modern and slick design, but we should still be able to display lots of information. - Keeping the existing content: The new design should maintain all the current content and functionalities. - We have had lots of SEO work done throughout the years and we would like to keep as much of that progress as possible, as well as add in some new SEO efforts. - Emphasis on mobile responsiveness: The new website must be highly responsive on all mobile devices. - An organized navigation that is less confusing then the current is a major focus for this project as well. The current site is www.rivell.com. The most creative/functional submission will be rewarded and expected to work with us on edits and changes that we feel are necessar...

I'm looking for a graphic designer to create a series of flat map pins in SVG format. These map pins will be used as part of an online map system, so they need to be clear and easily identifiable. Key requirements: - The pins should be flat in style and incorporate a logo. - They should be distinctive and clear, appropriate for display on a map. - The final deliverables must be in SVG format. - 6 different types of pins are needed, which will explain more to the winning candidate Ideal skills for this job: - Strong graphic design and illustration skills. - Proficiency in creating SVG images. - Understanding of colour theory and design for clear visual communication. - Experience in creating icons or similar graphic elements for digital use. Budget = $20

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

...its capabilities - Voucher functionality: Users can purchase vouchers at half price. - Condition: To avail the voucher, the user must share the app link with 10 other users. - Success criteria: If the user successfully shares the link with 10 users, they can redeem the voucher at half price. - Failure criteria: If the user fails to share the link with 10 users, they will receive a 10% discount on the voucher instead. Some more questions - Can the voucher sharing process be automated or tracked within the app? Ideal Skills and Experience: - Proficient in mobile app development, particularly customization on existing apps. - Strong UI/UX design capabilities to ensure a seamless user experience. - Experience with integrating push notifications and payment...

Thank you!

I have a financial plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file,...

...fresher-friendly employer, I'm looking for a web designer with knowledge of PHP. Your task is to craft a comprehensive online portfolio for me. Key Requirements: - The portfolio must have a user-friendly, aesthetically pleasing design. - I need a contact form integrated for potential clients to easily reach out. - An image gallery to showcase my work is essential. - A testimonials section is needed to display feedback from my clients. The site must be professionally designed, with no less than 10 pages. You're welcome to suggest additional features that could enhance the site's performance. Ideal Skills: - Proficiency in web design and development. - Strong command of PHP. - Experience in creating dynamic and appealing portfolios. - Familiarity with integrat...

...engineer or designer to work on a comprehensive mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria...

...the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own character. - Stories, plots, and actions are developed collaboratively, with everyone staying true to their roles and following the rules. 3. **Dedicated Servers**: - Roleplaying occurs on dedicated servers for the PC version of Grand Theft Auto V, as this mode is not available on consoles. The Project Vision: - **Recreate the GTA RP Experience in Minecraft**: - The goal is to build a Minecraft map that mirrors the GTA RP server's environment and dynamics. - This will involve detailed world-building to capture the essence and activities available in GTA's sandbox environment, translating t...

Pleas read the attached document

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment capacity." ...

I'm in need of an experienced app developer to create a mobile application for catering services on the Android platform. Key Features: - Menu Display: The app should allow users to browse through our catering services menu. - Order Placement: It should facilitate users in placing orders directly through the app. - Payment Integration: The app must have a secure payment gateway to enable seamless transactions. Ideal candidate would have: - Proven experience in Android app development - Prior experience in developing e-commerce or service based apps - Familiarity with integrating payment gateways into mobile applications - Strong communication skills to ensure a smooth collaboration and understanding of requirements. I have a DJ and catering services business, ...

I'm in need of a competent web developer to craft a straightforward website for my courier business. The ...need of a competent web developer to craft a straightforward website for my courier business. The site will be primarily focused on providing clients with package tracking information. Key Website Pages: - Home Page: This will feature my company's logo, name, and contact information. - Tracking Page: This is where clients can input their tracking number to see the current status of their package. It should also display an estimated delivery date. The ideal freelancer for this project should have experience in web development and a strong understanding of user experience design. A good communication skill is also preferred, as I'd like to be updated regu...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT o...

I'm seeking someone highly skilled in WordPress, with a strong sense of design, and excellent English proficiency to make comprehensive changes to my company's webs...Functionality**: I aim to incorporate new filters and category widget to enhance user experience and allow for better navigation and content discovery. The ideal freelancer will: - Have a strong portfolio showcasing their WordPress expertise and design sense. - Be proficient in English to ensure effective communication. - Have experience in adding new features and functionalities to WordPress sites. - Display a keen understanding of creating clean and professional design. If you're confident in your WordPress skills, design capabilities, and can manage a comprehensive website overhaul, I'd love to...

I need a clean, professional Wordpress website created for my brand. It must be simplistic, user-...- it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B websites - Design ability: keeping it simple, yet professional - Knowledge of SEO best practices to implement on the website. Please provide examples of your previous work, especially if you have exp...

...in managing and optimizing paid advertising campaigns on Google and Facebook to generate high-quality leads. You will be responsible for strategizing, executing, and analyzing ad campaigns to drive conversions and achieve business goals. Responsibilities: Campaign Strategy and Planning: Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to various audience segments. Set up and manage multiple ad campaigns across Google Ads (Search, Display, YouTube) and Facebook Ads (Feed, ...

I'm looking for a freelancer to recolor and enlarge my logo for web use. The current colors are too bright, so I'd like them to be shifted to a darker hue. The job will also involve resizing the logo for optimal web display. Ultimately, I would need the final version of the logo in JPEG format. Ideal skills and experience for this project include: - Graphic design and logo editing - Proficiency with Adobe Illustrator or similar software - Understanding of color theory - Experience with resizing images for web display

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.

I'm in need of a generative artificial intelligence that can analyze given text inputs and provide suggestions based on the analysis. The main purpose of this AI would be for data analysis. Key Requirements: - The AI should be primarily text-based. - It should be able to process and analyze the supplied text. - The output should be suggestions derived from the analysis. Ideal Skills and Experience: - Previous experience in developing generative AI systems. - Proficiency in natural language processing and data analysis. - Strong understanding of machine learning algorithms.

...handled via serial communication. Additionally, the system should include a quadrant display using 4 LEDs to indicate whether it is operating in motor or generator mode. All datasheets and circuit diagrams will be provided. Key Responsibilities: Control and Regulation: Implement SVPWM on both grid and machine sides. Grid-side control: Adjustable power factor (cos(φ)), current, and power. Machine-side control: Adjustable field (Φ), torque, and speed. Overload Protection: Develop a feature to switch the device to idle mode during overload conditions. Measurement and Output: Provide optional output of all internal measurements, especially torque, speed, and power. User Interface: Implement a 4x20 LCD text display for function calls. Enable function calls...

Hello I am looking for an experienced freelancer to help me create an account on , an online translation platform. The selected freelancer will not only be responsible for creating the account but also have the opportunity to use the account for their own translation needs. **Requirements**: * Hold a valid translation certificate or degree in one of the following languages: + English to French, Spanish, Italian, Japanese, or Chinese * Provide a detailed CV highlighting your translation skills and experience * Be able to pass 's verification process with your valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials for the client to

I'm in need of a skilled React app developer who can create an elegant and professional application for the general public. Key Features: - User Authentication: The app should have secure user registration and login functionality. - Real-time Data Updates: The app should be able to display real-time data updates to users. - Integration with External APIs: The app should be able to consume and display data from external APIs. Requirements: - Proven experience in React app development. - Strong design skills to deliver an elegant and professional user interface. - Understanding of user authentication and real-time data handling. - Familiarity with integrating external APIs. Orange money and MoMo The app is aimed at the general public, so it's important that it...

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

...to select the DSC ( usb token) inserted to the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utilities or tools - Familiarity with e-signing mechanisms and standards - Prior experienc...

I am currently in need of a skilled professional who has expertise in image editing. The task involves: - Removing the background from a batch of product images. - Correcting the color of these images for optimum display and output. - Inserting specific text into the images. The text will be designated into a specific area within each image, and it requires a keen eye for detail to maintain uniformity and consistency across all uploads. The ideal freelancer for this job would have a good understanding of photo editing software such as Photoshop or Lightroom, and a balance of creativity and precision. Proven experience in product photography editing is needed, with a portfolio to back it up. This role requires the balance of a creative eye and technical proficiency. If you c...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a proj...

I've created an Android app and now I'm seeking a skilled developer who has experience with Google Play Cons...deploy this app for me. Key Project Requirements: - The app is ready for deployment, so the main task is publishing it on the Google Play Store. - The developer should have a deep understanding of Google's app deployment process and the ability to navigate the Google Play Console efficiently. Ideal Skills: - Proficient in Android app development and deployment. - Prior experience with Google Play Console. - A good understanding of app store policies and guidelines. - Strong communication skills to ensure a smooth deployment process. Please note that I currently don't need assistance with creating promotional materials for the app listing, so the p...

I'm looking to create a comparison website to help potential traders assess and select proprietary trading firms in the finance industry. Key Requirements: - The site should have a comprehensive database of different proprietary trading firms, their key features, and offerings. - Users should be able to filter and compare the firms based on various criteria like trading strategies, capital requirements, and more. - A user-friendly interface and robust backend that can handle large amounts of data and provide real-time updates are crucial. Ideal Skills & Experience: - Web development experience, particularly in building comparison websites. - Understanding of finance and proprietary trading firms. - Proficiency in database management and user interface desig...

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specif...Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import fo...

I need a skilled developer to create custom functionality for my WordPress site using JavaScript. This new feature will be integrated into a specific existing page on my website. I need a site, showing the villas and providing the same experience for visitors. This site has many villas and features, including filters, maps, and search functions. It has 120 villas. I need the search filters and map filter search the same as reference site. The site has a big map showing areas like North, West, etc. When you click on an area, it should display the villas in that region. If you can make a similar map feature, that would be great. Let me know if you can do this.

I am looking for an experienced 2D or 3D animator to create a promotional video for our shop display. Key responsibilities include: - Conceptualizing and developing a compelling 2D or 3D animation narrative that effectively promotes our products. - Collaboratively working to ensure the video accurately and engagingly represents our brand. Ideal Skills: - Strong experience in 2D animation - Proficiency in using animation software - Ability to translate our brand vision into a captivating animation narrative - Proven portfolio of past animated promotional videos - Understanding the retail environment and shopper behaviors would be a plus. An excellent freelancer will be able to effectively balance creativity and strategic thinking to deliver an animation that not only visually ...

...work on my application. It will run on various platforms including Mobile device, Android TV OS, and Tablet. Existing Application will be shared with you . Key features of the application will include: - BLE Capture: Ensure the application can capture BLE data in real-time. - Data Uploading: Implement a mechanism for uploading collected data to the cloud. - Single Page Display: Design a single, easy-to-navigate page for the application. - Settings Page with Reports: Add a settings page where users can configure the app and view reports. - Devices Settings: Create a section for managing connected devices/settings. Key requirements: - Proven experience in developing Android apps, especially those involving BLE capture and cloud integration. - Strong UI/UX design s...

...captivating anamorphic display content. This project aims to develop visually striking 3D animations that utilize anamorphic illusions to enhance public spaces, highlighting innovative design and cultural heritage through interactive digital art. Requirements: -Proficiency in Blender for 3D modeling and animation, with a strong portfolio showcasing relevant work. -Experience in scripting within Blender to automate tasks and enhance animation functionalities. -Knowledge of integrating Blender projects with other software for interactive displays. - Demonstrated ability to work on projects that combine art and technology, particularly in public or large-scale settings. Deliverables: A series of high-quality anamorphic animations designed in Blender, ready for public ...

I'm looking for a creative designer to craft a modern, text-based logo intended for online use (websites, social media). The Word is XConn which needs to be designed. Following example is for proof of concept. XConn represents cross-platform connectivity, so a little touch of that in the logo would be a bonus Key details: - Style: The design should reflect a modern aesthetic. I'm not after overly complex or vintage styles but rather something sleek, clean, and current. - Color: I don't have a specific color palette in mind. I'm open to suggestions, so feel free to utilize colors that align with modern design trends. The ideal candidate for this project will: - Have a strong portfolio that demonstrates expertise in modern logo design. - Possess a keen eye for t...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated ...