How to filter multiple columns in excel jobs

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(4...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, p...

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.

My Server that I access via remote desktop services has stopped allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is availabl...REmote desktop services will stop working because this computer is past its grace period and has not contacted at least a valid windows server 2019 License." I had this issue before about 4 months after I initially set up the server, I went through multiple steps to register and it began working again for the past 5 months or so, and now it has stopped again. I need someone to help configure/reconfigure the server properly to allow remote desktop to function properly. I have physical access to the server and can work at th...

...graphic designer to help me create visual content for my business across various social media platforms. Key Requirements: - Experience with designing for Facebook, Instagram, Twitter, and LinkedIn - Proficiency in creating minimalistic graphics - Ability to work with specific colour schemes and branding guidelines Your role will involve: - Understanding the provided colour schemes and branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging and effective social media content. Experience i...

...entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs with contrasting elements which lead the eye toward the center of the icon are preferred. > The core design should be in vector format, with .ai (CS3 compatible) and .eps for...

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 am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to...

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

I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems, I would love to hear from you.

...System **Description:** We are seeking an experienced freelancer to develop and implement a robust outgoing predictive dialer system for our call center operations. The ideal candidate will have a strong background in telephony systems, database management, and CRM integration. The dialer should support dynamic caller ID, IP whitelisting, multiple campaigns, and a minimum of 10 representatives. **Responsibilities:** - Develop an outgoing predictive dialer system that integrates with our existing telephony infrastructure. - Implement dynamic caller ID functionality. - Ensure the system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search cl...

I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly app...

I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a pro...

I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.

...developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritiza...

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.

...specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can provide a translation in English later

Thank you!

I need an email validator that validates multiple emails, preferably done in C#. As stated above, I need a system that validates whether the email exists or not. The system must be practical and easy and must have a license management system, which I can generate. I want only people who pay some plan for the system to be able to use the software.

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

...digital marketing professional who can effectively handle multiple areas of digital marketing. This includes: - SEO: Enhancing the visibility and ranking of my website on search engines. - SEM: Implementing strategies that increase the reach and visibility of my ads. - Social Media Marketing: Creating engaging and shareable content for various social media platforms to build strong relations with the audience and increase followers. - Blogging: Producing high-quality blog posts to engage readers and increase site traffic. - Web Editing: Tweaking and enhancing the website for a more user-friendly experience and better SEO performance. - Email Marketing: Developing and managing effective email marketing strategies to boost customer engagemen...

We are seeking a talented and experienced 3D designer to create a highly detailed and customizable 3D model of a chair for our e-commerce website. The model should allow users to configure various elements such as textures, chair legs, and other features in real-time on our site. Requirements: Model Specifications: A highly detailed 3D model of a chair. Different textures and materials for customization (e.g., fabric, leather, wood). Multiple chair leg options (e.g., wooden, metal, various designs). UV unwrapped and properly textured for high-quality rendering. Technical Requirements: Formats: FBX, OBJ, and any other formats compatible with web-based 3D viewers. PBR Texturing: BaseColor, Normal, Roughness, and Metalness maps. Optimization for real-time renderi...

I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.

I'm in need of a skilled UI/UX designer proficient in wireframing, prototyping, and conducting user research. You will be working in accordance with our existing brand guidelines, ensuring a seamless integration of the new designs into our brand image. This is a bit of a dual platform job as you will be designing for both desktop and mobile interfaces. Experience in designing for multiple platforms is much desired. A sharp eye for detail and ability to create user-friendly, engaging design are the key skills needed for this project.

I'm in need of a 3D artist who can create a basic product model for me. This model should be able to be viewed from different angles. Key Requirements: - The project involves product modeling, so experience in this area is essential. - The model needs to be created with basic shapes and forms. No complex detailing or textures are needed. - You must be able to generate multiple views of the model, allowing me to see it from different perspectives. Ideal Skills and Experience: - Proficiency in 3D modeling software, such as Blender, Maya, or 3ds Max. - A strong portfolio demonstrating previous experience with product modeling. - A keen eye for detail and the ability to follow design specifications accurately. - Excellent co...

...with a couple of issues on my site. Key Requirements: - Fixing a bug causing the website to load slowly. - Enhancing website speed by employing appropriate techniques. Specifics: - The main issue I need addressed is the slow loading time of my website. This should be the primary focus. - Speed optimizations should be applied to the homepage as a top priority, but I also require this across other pages of the site. Ideal Skills and Experience: - Proficiency in WordPress development and bug fixing. - Experience in optimizing website speed, including image and media optimization, content caching, and server response time reduction. - Proven track record of improving website performance across multiple pages, with a keen eye for detail and thorough te...

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

I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.

... user-friendly, and designed to cater to B2B customers. The primary purpose of this website is to serve as a platform for displaying multiple products from our brand. There will be no ecommerce functionality - 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, y...

...seeking a seasoned logo designer to create an iconic/symbol representation logo for my brand. Ideal Skills and Experience: - Extensive experience in logo design - Expertise in using color psychology in design Specific Requirements: - The logo should serve multiple purposes, including brand identity, marketing materials, and website use. - The color scheme is already decided, but you need to have an understanding of color matching and visual appeal. - You should be able to create a visually captivating, yet simple, iconic/symbol representation logo. - An understanding of my brand and vision is essential to create a logo that reflects our values and appeals to our target audience. In your proposal, please feature pa...

...Specialist to join our dynamic marketing team. The ideal candidate will have a proven track record 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 va...

I'm in need of an expert blockchain developer, specifically experienced in Solana, to work on a bot development project. The key functionalities of this bot will focus on trade execution. Key Project Details: - Primarily, you will be working on a bot that executes trades within the Solana ecosystem. - Familiarity with Jito Bundles, Raydium, and Jupiter DEX is a huge plus. - The bot should be developed using Node.js. Requirements: - Proficient in Solana blockchain development. - Strong expertise in Node.js. - Proven experience in developing trading bots. - Prior experience working with Jito Bundles, Raydium, and Jupiter DEX is highly desired. - A good understanding of trade execution strategies in the blockchain context. Please note:...

...Writer position offers a unique opportunity to further develop your career in the field of drug safety. Key Responsibilities: Independent authoring, editing and reviewing of various regulatory/clinical documents (e.g. aggregate reports, risk management plans and other documents needed throughout the product’s life cycle) with the responsibility for the quality and content of the document and compliance with internal and external standards. Active participation in trainings and development, implementation and maintenance of quality system documents for medical writing, including internal templates and formats required for standardized documentation. Support in all pharmacovigilance operations associated with medical writing. Continuous self-education ...

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

...Script specialist with a proven track record in creating high-accuracy indicators for TradingView. The goal is to produce an indicator that can deliver buy and sell signals with exceptional precision, particularly when applied to short timeframes ranging from 1 to 5 minutes. Key Requirements: - Development of a Pine Script Indicator: The main task is to design an indicator that generates both buy and sell signals. The accuracy of these signals is crucial, and they should be specifically tailored for the 1-5 mins timeframe. - Incorporation of Multiple Trading Indicators: While I do not have a specific strategy in mind, the ideal candidate should be well-versed in using a variety of indicators to create a robust and reliable ...

Looking for a skilled developer to help with an issue related to Livewire gadgets. The key points of the project are: - The problem: Currently, the save functionality of one of the gadgets, namely Index Filter, is not working as intended. It's not saving data correctly. I need this to be fixed. -Also need to fix livewire library issues please Ideal candidates for this project should have: - Proven experience with Livewire gadgets - A strong understanding of database systems, particularly in the context of web applications - The ability to troubleshoot and solve issues efficiently - Strong communication skills to understand and implement the necessary changes to the saving mechanism.

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.

I'm seeking a skilled developer to create a versatile e-signing utility. This tool should allow users 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 ...

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

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

...looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to calculate their incentives. Key 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 developme...

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.

...coaching sessions. The purpose of these sessions is to test and provide feedback on various adult-rated counselling techniques. Key Responsibilities: - Participate in individual or couple's counselling sessions focused on intimacy and relationship enhancement. - Engage with and provide honest feedback on different counselling techniques. - Maintain open communication with the counsellor to ensure the effectiveness of the methods used. - Ensure confidentiality and a respectful approach throughout the process. Qualifications: - Must be open-minded and comfortable discussing a wide range of intimate and sexual topics. - Strong communication skills and the ability to provide constructive feedback. - Willingness to participate in multiple...

...seeking a highly organized and tech-savvy Virtual Assistant to join our team for a 6-month fixed contract, with the possibility of renewal in 2025 based on performance. The ideal candidate will have experience with content creation and management, using tools such as ChatGPT, WordPress, and social media platforms. This role is perfect for someone who is passionate about technology, fashion, beauty, lifestyle, and the metaverse. Responsibilities: -Assist in planning and executing a comprehensive content calendar for our blog, podcast, and social media channels (LinkedIn, Instagram, TikTok). -Create engaging and high-impact content, including blog posts, social media updates, and podcast summaries. -Conduct thorough research on current trends in tech, fashion,...

...Basic Audio Note Organizer App (Working Title) Project Description: I need a web application developed to manage and organize short audio recordings. Users should be able to upload audio files (3 seconds max) and categorize them with basic labels. Key Features: User accounts and login system Ability to upload audio files (3 seconds max) - MP3 format preferred Option to add simple labels (e.g., "Meeting Notes," "Quote") to each audio file Ability to sort and filter audio files by upload date or label Basic interface for browsing and listening to uploaded audio files Secure storage of user data (audio files and labels) Target Audience: This app caters to users who want a simple way to organize a...

I'm look...a skilled Flutter developer who can help me build a multi-platform application that is set to be a long-term project. My primary goal is to have a reliable app that includes a variety of features to provide a seamless user experience. the app which we building will be used 24/7/365 non stop always on Skills & Experience: - Proficiency in Flutter development across multiple platforms (Android & iOS , Windows , Web). - Strong understanding and experience with user authentication, push notifications, and local database management. - Prior work with Firebase authentication . - Experience in hardware and IoT integration . THIS IS A LONG TERM PROJECT IS NOT A ONE TIME THING AND IT MIGHT TAKE A YEAR TO FINISH PLEASE...

Looking for someone to develop a simple mobile app that will work on both iOS and android. That would mean utilizing one of those frameworks such as React Native or Cordova (or something else similar). The app will basically just allow the user to search for an order (done through a Rest API) and then select photos on the device and upload those to the selected order (also though a Rest API). Detailed Requirements: Setup screen where system URL and API key can be entered and then saved so subsequent uses of app doesn't require it to be reentered Ability to search and find order using order number, customer name, or company name Ability to select multiple photos and upload at once (although API call needs to be made for each ...

I am in need of an expert in Apache Camel 3.3.0 and Spring DSL for a project focused on system integration. Here's what I require: - A thorough familiarity with Apache Camel 3.3.0. - Strong proficiency in Spring DSL. - Capability to successfully integrate multiple systems. - Clear understanding of data transformation, routing, and error handling, although these are not the primary focus. The ideal candidate should have a working knowledge of the latest Apache Camel version and the utilization of Spring DSL. Any prior experience with system integration projects would be an added advantage. Looking forward to receiving bids from capable professionals.

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