How to remove data in excel using formula jobs

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

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

I kindly ask for payment that I did up to here: - Inspect the code and remove Invisible mode section on profile page for mobile and desktop theme - Enable/fix youtube video's sound for desktop version of script

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

I need a master of Photoshop to expertly remove an object that is centrally placed in my photo. The object to be removed is distinctly separate, none of the elements in the image overlap or intertwine with it. The ideal freelancer for this project should possess: - Exceptional Photoshop skills, particularly in object removal - Keen eye for detail to maintain the integrity of the remaining elements - Experience in image manipulation and restoration projects. Your goal is to make the final image look as natural as possible, as if the object was never there to begin with. Efficiency and promptness is appreciated.

...meetings are expected to continue for three days each. - All meetings will be conducted in-person. - Clarity and audio quality are of utmost importance. - Quick turnaround time is crucial. Required Skills & Experience: - Proven experience in professional audio recording, particularly in meeting and conference settings. - Strong attention to detail and professionalism. - Fast and efficient, without compromising the quality. - Excellent time management skills. - Ability to handle unforeseen recording challenges that may arise. - Familiar with different audio formats and compression settings, to deliver the final product in the desired format. - Understanding of audio editing, to remove unwanted disturbances...

...for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that wi...

...web developer to create a fully functional e-commerce website. The site will be dedicated to selling a range of products and will need to incorporate various key features to ensure a smooth and secure shopping experience. Key requirements: - The website should have a visually appealing and user-friendly design, with a clear focus on the products. - The primary goal of the site will be to facilitate online sales, so it's essential that the developer has experience in creating successful e-commerce platforms. - It's crucial that the site supports a shopping cart feature, enabling customers to add, remove, and manage their selected products easily. - Customer reviews play a significant role in building trust and cred...

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

I'm in need of assistance managing my team roster. The main tasks include adding new team members, updating details for existing ones, and removing team members as necessary. Key Responsibilities: - Adding New Team Members: I'll provide the necessary information for new team members. You'll be responsible for ensuring their details are accurately added to the roster. - Updating Existing Team Members: There may be changes to the current team members' details (e.g. position, contact information, etc.). You'll be updating these details accordingly. - Removing Team Members: As we continue to evolve, there may be a need to remove certain team members. You'll be responsible for removing them from the roster. Ideal Skills: ...

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to...

I'm looking for a skilled freelancer with experience in image stitching using OpenCV. The primary goal of this project is to merge two images into a single image. Project requirements : You will be able to choose 2 grayscale images from the graphical interface. The images will be read from the disk and displayed, and the mouse will be used to choose corresponding points on the images (at least 3). Pairs of dots will be marked with crosses of the same colour in the images, but distinct (random choice of colours) for each pair. After pressing a key a third image will be displayed containing the first image pasted to the second image on a black background. For this, the image registration algorithm will be implemented, which calculates...

I'm seeking a skilled professional well-versed in MAXQDA software and data analysis to assist with my upcoming project. The work will involve the analysis of multiple sets of data - primarily surveys, interviews, and focus groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating system, is highly des...

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

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

I'm looking for a skilled photo editor who can completely remove sun rays from an outdoor photo featuring a motorcycle and a person. Your expertise in professional photo editing and manipulation will be crucial to achieving a flawless end result. Here are my requirements: - Complete removal of sun rays from the image. - Retain the overall quality and integrity of the image while executing the task. - Experience working with outdoor photography and dealing with lighting elements. - Excellent attention to detail to ensure a natural look after removal. - The ability to work efficiently to deliver the project within the agreed timeframes.

I'm looking for a qualified ...looking for a qualified Android developer who can modify an existing apk for me. I need some specific modifications to be made. Requirements: - Remove license code request. - Disable external server connection to - Make sure the "REPLACE" button continues to work as intended. The purpose of the "REPLACE" button in this apk is to inject pre-recorded video into the native Android camera or stream transmitted via obs from the pc into the native Android camera. This is a crucial functionality of the apk that needs to be maintained and work perfectly after modifications. Ideal Skills and Experience: - Proficient in Android application development. - Experience in modifying ...

...specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyw...

...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add anothe...

I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel fi...

...combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in...

Design of Digital filter algorithm/ code in C for ARM processor for processing real time raw sensor to removal of noise & unwanted signal Algorithm / code for Digital Filter low bandwidth Real time Sensor Signals 1. Analogue Raw data acquisition in real time at 1000 samples per second in 24 bit precision 2. Raw data signal bandwidth /frequencies restricted to less then 1000 hz by hardware RC anti aliasing filter to avoid aliasing 3. Following Digital in sequence to be applied to raw signal . a. low pass filter 0-170 hzs ( to remove high frequency random / white noise b. High pass filter 1 hz to 400 hz (to remove low frequency dur DC signal coupling ) c. Very steep(...

Creating thumbnails and banners for Google Chrome Extension Thumbnail 440*280 The main task when drawing this banner is to force users to pay attention to your extension. This banner should be simple, minimalistic, and immediately convey the general essence of the extension. Also, this banner should attract attention. - Use contrast background - Use logo and name: “Time Zone Meeting Planner. - Size: 440*280 - Format: png Big banner (screenshot) 1280*800 A simplified screenshot of the extension conveying the essence of the product, and not necessarily all the functionality of the product. - Use a screenshot, remove all secondary elements (settings, offset, etc) - Draw a mouse and its movement while selecting time - Use text: “Find the best...

I'm looking for an experienced social media manager who can help me in creating and scheduling 200 posts for LinkedIn, Facebook, and Instagram. The posts will aim to target the Saudi market, focusing on Saudi public holidays, patriotism, and more. The requirements for this job are as follows: - Create 200 posts: The posts should be engaging, creative, and tailored for a Saudi audience. They should include high-quality, royalty-free stock photos and be bilingual in both English and Arabic. - Schedule posts: Utilizing Odoo Social Marketing, the successful candidate will be responsible for scheduling these posts for optimal times to reach the target audience. - Target Saudi Market: Understanding the Saudi culture and market is crucial. The posts should resona...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry...

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natur...

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

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

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

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

...cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically award to bidded products as admin can set

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

I'm in need of a seasoned designer to urgently modify the layout and add/remove elements of an existing design. Knowledge of Arabic calligraphy will be helpful. Key Responsibilities: - Revamp of the existing design layout - Tactful addition and removal of design elements Ideal skills: - Proficiency in common design software - Excellent eye for layout modifications - Experience in promptly delivering high quality work Please note while the area for modifications isn't specified, expect a comprehensive review of the design. Freelancers having immediate availability for fast-turnaround will enjoy preference.

I have a set of images with barcodes on them and I need specialized enhancements. Primarily, I'm seeking a freelancer with advanced image processing capabilities to make my barcodes highly readable. Specific Requirements: - Adjust the brightness of images to improve readability. - Enhance the colors for clarity. - Remove any background noise which may be obstructing the view of the barcodes. The ultimate goal is to make it easier to read the actual numbers under each barcode. As timing is imperative, I require this project to be completed ASAP. Ideal Skills & Experience: - Proficiency in Image Processing and Enhancement - Experience with Barcode Recognition - Excellent Speed and Efficiency.

Task Require 1. Remove Background. 2. Save as white & black background.

I have a set of photos taken with my phone that I need to be optimized in Photoshop. These pictures will be used to promote my moving and transport company. Optimizations: - Adjust Brightness and Contrast: Enhance the visual appeal of the images. - Crop and Resize: Ensure the photos are suitable for multiple marketing platforms. - Remove Background: Enhance the professionalism of the images by removing any background distractions. - Logo Inclusion: Incorporate my company's logo onto the images in a way that makes it appear as though it's a natural part of the vehicles. - There are around 25 pictures attached for you to choose from, but i only need 10 max 15 to be edited. You need to use your experience in choosing w...

...canonical errors. To elaborate, certain sections of my website, including the homepage, blog posts, and product pages, are experiencing these technical glitches. I require an expert with proficiency in the following: - In-depth knowledge of WordPress SEO - Proficiency in handling technical SEO components, specifically noindex tags and canonical errors - Experience in indexing website pages Your task will be to: - Effectively remove the noindex tags from the specified pages - Accurately fix canonical errors on these pages Ive literally tried EVERYTHING and nothing will get my website indexed properly This job entails dealing with both components mentioned, namely removing the noindex tags and fixing canonical errors. Your comprehens...

Payment will be paid according to each repo in MS Projects' Jira system The payment calculation will follow the actual time for each repo except the time to fix bugs.

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

I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on...

...your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we hav...

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

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

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

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

I'm seeking a skilled individual to urgently delete misleading information from a Wikipedia account. Who has an active and old wikipedia account. To also do source analysis and vote. Key Tasks: - Identify and remove misleading content: The primary task is to review the existing content on a Wikipedia account and identify any information that is misleading. Once identified, this content must be permanently deleted. - Ensure Compliance: The successful candidate will need to ensure that the content removal process complies with Wikipedia's guidelines and policies. This includes avoiding the removal of any content that may be perceived as neutral and supported by reliable sources. This project is time-sensitive. Immediate action is required to...

...CSS, and knowledge of Javascript JQuery is also must. Aim to enhance an existing PHP/Laravel code base to improve its functionality and remove bugs by testing the code. Estimated budget is small between 450$ to 650$ so please quote your bid carefully, it will be release through monthly payout from Freelancer. Based on performance the monthly amount would certainly be increased. The prospective candidate should be able to commit 6 hours per day Monday to Friday. Meeting software could be any of the MS Teams, Zoom, Google Meet, etc. Working time zone preferred is Europe GMT + 0 Key Responsibilities: - Understanding of SECURE PHP code development with proper code comments, file names, package management, branching, deployment using GI...

We have a B2B WordPress website that fails Core Web Vitals on m...Vitals on mobile and desktop. The site was originally made by one developer, then worked on by another, resulting in many issues due to lack of communication. The website uses Elementor and a customized theme. We would like to work with an expert WordPress developer to improve the site's performance and get it into the green in Core Web Vitals. We also want to remove all unnecessary plugins (currently the site has almost 50 WordPress plugins). We are open to moving the site to a new server if required and rebuilding it to improve performance. Looking to work with an experienced WP developer and performance expert to solve this. Please ...

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

...Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience ...