Excel filter data based on cell value jobs

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.

...Handling this many files can be a challenge for an untrained person, and I need an expert on my team. The project requires: - Knowledge and understanding of Kobo E-readers and Sony E-readers - Familiarity with E-book file formats - Able to deliver a precisely organized outcome Handling this quantity of files is no minor task, so I will place high value on the following skills: - Excellent organizational skills to ensure the easy location of each ebook post-transfer. - An understanding of ebook cataloging - managing metadata may become essential - Problem-solving skills, should any issues arise during the transfer process If you can ensure a smooth, error-free transition across devices, I want you on board. This task needs in-depth knowledge, meticulous...

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

...searching for a talented graphic designer to work with on a long-term basis, contributing to various projects for my team. The ideal candidate will have the following qualities: - **Experience:** I require someone who has a solid background in graphic design, with a proven track record of successful projects. Your experience should cover a range of graphic design areas, ideally with a specialization in modern and minimalistic styles. - **Creativity:** I need a designer with a knack for generating innovative ideas. A strong creative vision will be a key asset. - **Portfolio:** Please be ready to showcase your portfolio, along with your previous works. This will help me understand your style and experience better. - **Communication:** I value clear and efficient commu...

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.

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 ability to identify and extract the ...

I'm currently seeking a professional with extensive experience in structural engineering, especially older homes. My property is an 1890s house in Michigan requiring structure optimization for joist, rafter, and beam/collar tie to better withstand our moderate winters. Unknown to me is whether or not the house c...Being familiar with Michigan's weather conditions and how they impact a home's structure will be a plus. Your recommendations and solutions should effectively address and prevent any potential instability or damage. Please include any relevant experience, project estimates, and methodological approach in your bid. Completion timeline is flexible and can be negotiated based on your professional opinion and strategy. We value quality, precision...

...market research and present it in a succinct, engaging way. - Business Model: I need a clear, concise explanation of how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project brings to the market and why it's a worthwhile investment. In terms of the length, I'm looking for something between 5-10 slides - it should be long enough to be comprehensive, but succinct enough to hold the attention of poten...

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.

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

...Mechanism Project Overview: We are seeking a skilled and detail-oriented freelance mechanical 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 select...

...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 want a strategy for tradingview that it opens the orders manually or crossing emas, we input a range for the stop loss and take profit using % or $ and when it reachs the SL it opens a new order using the same range and different direction, if it is long, turn in to a short but with the value increase by a pre set multiplier (one for the SL ad one for the TP) and also add a possibility to multiples TP We also need to pre set a limit of times that the reversion happens and also add a option tralling stop loss. Can you make it?

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 dataset of images and I'm looking for someone experienced in U-Net algorithm. Project description: - Write PyTorch U-Net training model on top of provided base code (, , , ). - Train the model until achieving a validation dice score of min. 0.875. - Deliver source code and trained model until Wednesday 10 pm (Vietnam time zone).

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

...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 output file and we have a value ...

I'm looking for an experienced domain broker to assist with selling a high-value domain in the technology industry. Key Points: - **Domain Expertise**: Familiarity with the technology niche is crucial. Understanding of the potential buyers and market, as well as the ability to articulate the domain's value. - **Negotiation Skills**: Proven ability to negotiate and secure high-value sales. Past experience in selling high-end domains would be a significant advantage. - **Professional Network**: A well-established network in the tech industry, particularly among potential domain buyers, would be highly beneficial. - **Confidentiality**: Ensuring all transactions are handled with the utmost discretion and confidentiality. I have a target price in mind higher t...

...Experience with data structure libraries (e.g., ) - Knowledge of modern authorization mechanisms, such as JSON Web Token - Familiarity with modern front-end build pipelines and tools - A knack for benchmarking and optimization - Familiarity with code versioning tools, such as Git - Familiarity with basic CSS, and Figma designing. **Preferred Qualifications** - Proficient understanding of TypeScript with ReactJS - Working knowledge of Tailwind CSS - Able to replicate Figma design to React code. - Experience in optimizing components for all browser platforms - Strong portfolio of both front-end and back-end development **What We Offer** - Competitive compensation package with an attractive hourly rate - Collaborative, fast-paced work environment - Opportunity to work on ...

I am looking for fre...Key Notes: - This is a commission-based role, and I intend to reward successful sales generously. - No website design or layout is required as the sale is purely for the domain names. - There are no specific keywords or phrases related to the domain names as they cover an extensive range of subjects. Ideal Candidate: - Knowledgeable about digital assets, particularly domain names - Proven sales experience, preferably in the digital marketplace - Highly persuasive and comfortable with cold outreach - A solid understanding of the value of domain names in today's market This isn't about creating websites. It's about selling potential scale, opportunities, and a vision to your audience. If you believe you can sell these domain names and m...

I'm in need of a proficient CSS Animation expert, comfortable with both vanilla JavaScript and React. Your task will involve incorporating specific animation effects into a project. Key Features: - Apply 'Fade in/out' and 'Rotate' animation component based on the value of the a sliding scale. - Work uniformly across both mobile and desktop devices. Ideal Skills: - Expertise in CSS and SVG animation - Familiarity with vanilla JavaScript and React - Strong understanding of responsive web design and development Flexibility in your use of vanilla JavaScript or React is preferred since I have no strict preference between the two. Anticipate demonstrating your ability to innovate and effectively apply your skills to create engaging user experience...

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'm looking for a skilled android developer to create a professional application for me. The app will be targeting professionals as the primary users. Key Features: - User Login and Registration: The application should allow users to create accounts and log in securely. - In-App Purchase Functiona...professional audience. Ideal Skills: - Proficiency in Android app development - Experience with in-app purchase integration - Ability to implement secure user login and registration systems - Prior work with push notification services - Strong design skills, especially in creating icons - Understanding target audience of professionals If you have additional expertise that you believe would add value to this project, please feel free to mention it in your bid. Looking forward to ...

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.

I need a general audience-focused, 800-1000 word article on club chair office furniture. The article should provide a comprehensive overview of the design, comfort, ergonomics, and durability of club chairs for office use. Key Points to Include: - Design and Aesthetics: Describe the aesthetic features of club chair office furniture and how they contribute to the overall appearance of an office space. - Comfort and Ergonomics: Highlight the comfort levels and ergonomic designs of club chairs, explaining how they can improve workplace productivity and employee satisfaction. - Durability and Quality: Emphasize the durability and quality standards of club chairs to ensure long-term use and value for money. - General Information: Provide general and informative content about clu...

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'm looking for a detailed and engaging article that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words,...professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professional and engaging, keeping the reader interested from start to finish. This piece should be well-researched, original, and truly showcase the value and importance of large conference tables in a workspace. Ideal Skills and Experience: - Strong research abilities - Excellent writing skills - Experience in content creation for furniture or office equipment ...

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 require an adept senior-level Chartered Accountant/Chief Financial Officer (CFO). My ideal candidate will maintain responsibility for: - Rigorous financial reporting - Diligent budgeting and forecasting - Effect...budgeting and forecasting - Effective cash flow management -Supervision of existing staff to facilitate GAAP processes and timely monthly close processes A deep and demonstrated understanding of auto parts industries is non-negotiable. With your experience, you will add significant value to my company's financial standing and strategic growth. Proven track record in similar roles is highly valuable. You will be working remotely, using the data we provide and other data that you gather to advise our leadership team on all financial matters and...

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 (e.g. Python, Java) - Experience in developing software ...

...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 project is on...

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

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

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.

Project Title: Basic Audio Note ...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 and access short audio snippets for personal use. Think of it as a basic audio version of a text-based note-taking app. Please Note: This is a very basic project focused solely on functionality. No need for fancy features like audio editing, playback speed control, or file sharin...

...Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in inventory management. - Attention to detail and accuracy. - Experience working with sales and inventory data. - Ability to work with specific data formats. - Reliable with good communication skills. Your support in thi...

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 am seeking a skilled developer to create a comprehensive multi-vendor e-marketplace. It should allow users to upload items for sale or auction - a feature thoughtfully designed like a chat system to facilitate communication before purchases is a must. It should also allow the ability for users to be ranked and achieve different tiers for purchases completed and track volume / dollar value of total transactions to date. Key Requirements: - Design: The interface should be clean and minimalistic, delivering a user experience that is simple yet effective. - Categories: The e-marketplace will need to cater to "Clothing and Accessories". - Seller Profiles: Profiles should be feature-rich, including options for ratings and reviews, order history, and displaying a seller...

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

As the client, I am looking for a skilled audio editor who can add value to my project with their expertise in creating seamless transitions between audio segments. My main objective is achieving a consistent, smooth sound for my audio files. Here are the main tasks involved in the project: - Conduct concise audio editing on the provided files. - Implement crossfade for the transitions to create a uniform sound throughout. The perfect freelancer for this project will have significant experience in audio editing and specialize in creating smooth crossfade transitions. Prior experience with professional audio production and a great understanding of minimising noise interference will also be highly beneficial.

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient ...with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me res...

Responsibilities: Develop and execute a Twitter growth strategy. Create engaging, explicit content aligned with our brand. Analyze metrics and optimize strategies. Cultivate relationships with influencers and partners. Stay updated on Twitter trends and features. Requirements: Proven social media experience, especially on Twitter. Deep understanding of Twitter's platform and algorithms. Creative and analytical mindset. Comfortable with explicit content. How to Apply: Submit your resume and a brief cover letter showcasing your relevant experience and successful Twitter campaigns. We value diversity and encourage all qualified individuals to apply.

I'm in need of a skilled freelancer to assist in finalizing my email list building project. Your role will be to source C-Level leads and their contact details, ensuring they meet the specified criteria. Key Responsibilities: - Source C-Level leads in the techn...email list building project. Your role will be to source C-Level leads and their contact details, ensuring they meet the specified criteria. Key Responsibilities: - Source C-Level leads in the technology industry - Gather email addresses and LinkedIn profiles for each lead - Ensure all sourced leads meet the specified criteria This project requires you to source between 100-300 C-Level leads. I value accuracy and efficiency and am looking for a competent and reliable freelancer to assist in this final crucial step ...

I'm looking for an experienced Arduino and ESP32 LVGL programmer who is able to Build arduino code for a Waveshare ESP32 s3 Touch LCD 4.3 and recognize data from I2C ADS1115 interface a display grafically Display have to rappresent data in 4 different page changeable touching icons placed in down part of display In each page are displayed more rounded bar with % value received from 3 x ads1115 i2c connected Key Responsibilities: - Program the ESP32 to recognize and interpret the data from the I2C ADS1115 sensor module - Integrate a responsive touchscreen control and an LCD display on the Waveshare ESP32 s3 Touch LCD 4.3 - Ensure the system is user-friendly and able to display the sensor readings accurately - Implement the system in a way that is ...