Excel remove duplicates multiple columns jobs
I'm in need of a detail-oriented and communicative Virtual Assistant to manage key elements of my laptop r...payments & invoices - Assisting with keeping track of repairs using Zoho Desk - Handle customer support inquiries via Email, Phone, and Live chat --Respond directly to basic queries --Forward on relevant information to our local staff - Execute order management tasks The ideal candidate should have: - Excellent written and verbal communication skills - Data management and excel skills are critical - Ability to manage multiple tasks simultaneously - Familiarity with various customer support and order management tools - Available for 4-8 hours per day. - Experience with Zoho one - Understanding of laptop parts or experience in the laptop repair industry Plea...
I'm seeking a freelancer to assist with a simple data entry task. The project involves populating a spreadsheet with dates, expenses, and descriptions. I'll require this to be done just once. Key Requirements: - Entering data such as dates, expenses, and descriptions into a spreadsheet - The spreadsheet should consist of 3 columns - There will be about 200 rows I have made the spreadsheet already in Google Docs, all you need to do is fill it out with text from 200 File names which I will include This task is straightforward and should not take too long to complete. I'm looking for someone who can get this done accurately and in a timely manner. Please reach out if you fit the bill. Budget is ideally $10 AUD
...freelancer who can handle both video editing and excel management. - Video Editing: I have various types of videos that need to be edited. This includes marketing videos, tutorial videos, event videos, and reels. The ideal candidate is proficient in video editing tools and can create engaging, professional videos that suit different platforms such as social media, websites, and presentations. - Excel Management: On the other hand, I also require assistance in organizing and managing data on Excel. You should have a good grasp of Excel functions and be able to maintain and update spreadsheets effectively. Ideal skills: - Proficient in video editing software - Experience in creating marketing, tutorial, and event videos - Skilled in managing data on Exc...
...to bots bot_b, bot_c, and bot_d. After waiting to receive replies from bot_b, bot_c, and bot_d, if bot_b does not respond, a predetermined text is assigned as bot_b's reply. The replies from the three bots are then merged and processed, and the resulting text is sent back to the user by bot_a. However, during testing: when I send messages to bot_a, sometimes bot_a sends me the processed text multiple times, and other times bot_a does not respond at all. I ensure that the interval between messages I send to bot_a is sufficiently long, and each message is different. The content of bot_a's replies is correct, but the issue is that it is either repetitive or there is no reply at all. I need to identify the cause of these repetitions and non-responses. Please provide detai...
...entering high complexity data into Excel. The data is scientific research data and involves working with an extensive database. Key Requirements: - High level of attention to detail is crucial, as inaccurate data entry could have significant implications. - Familiarity with Excel and proficiency in data entry. - The data involves scientific research data, so any background in related fields would be beneficial. Tasks: - Entering the data accurately and efficiently. - Applying conditional data validation as required (e.g., specific formats or criteria for entries). - Ensuring the database is updated and maintained accurately. Ideal Skills and Experience: - Proven experience in data entry, ideally with high complexity data. - Strong understanding of Excel, particul...
I'm looking for an expert to scrape data from a website. I will provide the list of data (approx. 16K entries) that will be entered into the search bar and I need 2 fields extracted from each search into an excel sheet. This will be a one-off scrape of the website.
I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficien...
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....
I am looking for an experienced Pinescript coder to create a piece of code implementing the multiple combined technical indicator for my project. Below are the specifics of what I'm looking for: - Expertise in Pinescript programming with a keen understanding of TradingView's code language for custom technical analysis. - Profound understanding of technical indicators, especially the implementation of Relative Strength,RSI,ADX,Vstop,Psar - The code should be clean, efficient, and easy to understand with proper comments and documentation. Ideally, I'm looking for a developer who has proven experience in developing technical indicators in Pinescript and a good understanding of RSI. Previous work samples demonstrating the same would be appreciated. Your collaborative a...
I need a proficient Photoshop artist with a keen eye for detail to modify a photo for me. Here's what is required: - Add/Remove Objects: I need to remove a specific name from the photo and replace it with another name. This task requires precision, so prior experience in meticulous photo editing is mandatory. Ideal skills include proficiency in the latest Photoshop software and strong attention to detail. I'd appreciate seeing examples of similar editing work in your portfolio when you apply.
...dataset related to diabetes prediction. Specifically, I need help with: - Creating bubble charts, heat maps, histograms, and correlation matrices using my dataset - Thorough data analysis and identification of patterns and trends - Effective and clear communication of data insights that can aid in early detection and intervention of diabetes The primary data provided for this project includes multiple features such as BMI, age, and cholesterol levels, among others. An ideal candidate for this position would have: - Demonstrable expertise in data visualization tools - Strong analytical skills with the ability to identify significant patterns - Experience in health data, particularly diabetes-related, is a plus. Your objective will be creating visuals and stats that can ...
I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as you he...
We're looking for a skilled designer who can create a unique and abstract logo for our educational company which we intend to use across multiple platforms including our YouTube channel, social media accounts, and website. You will need to incorporate the following: - Utilize a color scheme based on blue, green, and purple. Flexibility in the use of these colors is appreciated - the essential part is integrating these in an aesthetically pleasing and cohesive manner. - Abstract design is preferred. The intent is to maintain simplicity while conveying our brand messaging effectively. Experience in abstract logo design will definitely be beneficial. - Incorporation of the suggested 'education' elements. The interesting part here is that instead of traditional images, ...
I am in need of a skilled video editor who can efficiently remove wind noise from my less-than-30-minute wedding footage. Consideration must be given whether to keep some level of background noise or completely eliminate it - your professional recommendation would be appreciated. Apart from the noise reduction, I also require color correction to enhance the overall video. Years of experience in similar projects and proficiency using video noise reduction and color grading tools will serve well for this project.
We need 6 Freelancers for this task but you should have very very strong knowledge of Medical related things. Medical equipment and the names of some Leading companies who make those products. I'm attaching some examples of task below. Will discuss more things on Zoom meeting. You will be provided a list with the name and images of products and you will need to assign them 1 or multiple keywords based on what kind of product it is. Like in the sheet (link attached) under "Smart Collections" You can see all of the tags we have. You will select related tags from this sheet. And "Sheet1" shows the names of products and how the final tags will look like. I did first entry for you to understand the task. Sheet link is here:
I'm in search of an experienced developer to create a responsive healthcare app that will incorporate telemedicine and e-prescription functionalities, including voice-to-text capabilities. The app must be compatible with iOS, Android, and Web platforms. Key Features: - Video and Text-based Consultations: The app should allow user...voice to text for e-prescribing medicine. Design Requirements: - Minimalistic Design: I'm seeking a simple and clean design that is easy to navigate. Ideal Skills: - Proficiency in app development, particularly in the healthcare sector - Experience with telemedicine and e-prescription functionalities - Understanding of voice-to-text capabilities - Previous work in creating responsive apps for multiple platforms. - UI/UX expertise focused on ...
I need a professional who can quickly and accurately input less than 100 rows of data into an Excel file. You'll be provided with all the necessary data, so there's no need for additional sourcing. Ideal Skills and Experience: - Proficiency in Excel - Fast and accurate data entry skills - Attention to detail to ensure correctness - Experience in working with data sets This is a straightforward project that needs to be completed quickly, so I'm looking for someone efficient and reliable. If the data entry is done well, there is potential for more work in the future.
...packaging margins. We have taken photos for 6 x food packaging designs and need all 6 done. We need to have the photos edited for inserting onto food packaging design. I've attached an example of the changes, with left being the photo that was taken and the middle being a very quick example (not to detail) of what we are after. Key tasks: - Carry out color correction on each photo. - Remove backgrounds where necessary. - Retouch each image to ensure there are no blemishes or imperfections. Once editing processes have been completed, the photos should be resized to a large size -12x18 inches, 300 dpi. The final artworks should be delivered in JPEG format. Ideal candidates will possess significant experience with photo editing software and understand the nuances o...
...templates to be creative and modern in style - Implement a color scheme of neutral colors (black, white, grey) Ideal Skills: - Proficiency in Microsoft BC 365 and Report Builder File - Strong understanding of template design and development - Experience in creating professional and modern designs - Ability to work with neutral color schemes - Attention to detail to ensure consistency across multiple templates It's important for the successful candidate to be able to work with the existing draft templates and requested information provided, and transform them into a modern and appealing design. Strong communication skills will also be beneficial to ensure the final templates meet the desired specifications. I have included a template of the labels with required informati...
1. Minifying the CSS and javascript files if required 2. Preloading or parallel loading of images with page 3. Setting for the caches for images and javascript files 4. Remove layout shifts if exists and more 5. Remove all caching plugins apart from LiteSpeed Cache. 6. Add text compression. 7. Eliminate render-blocking resources. Goals: Mobile Speed on Page insight around 75 to 80. Desktop speed will be above 80. Reduce the load time of the page. Gtmetrix around B to A
...developer with a strong sense of design and a flair for typography. Your key responsibilities will be: - Enhance website design: I want to modify the current color scheme and typography on my site to give it a fresh, modern look. Strong design skills and a good eye for color is a must for this part of the project. - Update Imagery and Content: I need to update the text and images across the site, and remove any content that is now outdated. Your ability to write clean, engaging copy and source high-quality images will be highly beneficial here. - Add desired plugins: In addition to the design and content updates, I'm also interested in integrating new plugins that can augment the functionality of my website. Experience with WordPress plugins is essential. Please make s...
I need an expert in photo editing who can help me remove a barely visible accident scar from a picture of my arm. This task requires precision as the scar is small, covering a minimal portion of the arm, and it's subtly visible. Experience with similar projects and an eye for detail would be advantageous. Please showcase your prior work when bidding.
I need an expert in photo editing who can help me remove a barely visible accident scar from a picture of my arm. This task requires precision as the scar is small, covering a minimal portion of the arm, and it's subtly visible. Experience with similar projects and an eye for detail would be advantageous. Please showcase your prior work when bidding.
In need of a proficient financial analyst with su...specifically for a venture capital investment. The ideal candidate should have proven experience in executing similar financial tasks with the following key competences: - Cash Flow Analysis expertise - Deducing MOIC and IRR Return on Investment - Cap table analysis Here's exactly what I need: - A critical analysis and revision of our existing cash flow. - Recalculating and modifying the MOIC (Multiple on Invested Capital). - Reevaluating and amending the IRR (Internal Rate of Return). Please note that the existing financial model is available for your perusal and to assist in making your accurate bid on this project. Your ability to methodically and accurately complete this task in a short period of time will be extrem...
I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, derived from...
I'm in need of a skilled Full-stack Developer to build a social...Integration of data storage solutions and ensuring high performance. Ideal freelancer's skills and expertise: - Extensive experience in full-stack development, including both front-end and back-end tech stacks. - Proficient understanding of web markup, including HTML5, CSS3, and JavaScript. - Strong knowledge of server-side MVC frameworks. - Experience in user authentication and authorization between multiple systems or servers. - Understanding of fundamental design principles behind a scalable and reusable application. -react the best its a team not just freelancer i share the design here
...with Teams or Zoom for meeting data * Transcription of meeting audio and video * Analysis of meeting transcription for insights and keywords Virtual Meeting Transcription and Analysis Component: Analysis Service * Processing and delivery of insights and keywords from meeting transcription * Integration with Azure Cognitive Services for NLP and machine learning Additional Features * Support for multiple languages and locales * Customizable user interface and branding * Integration with other Microsoft tools and services (e.g., Office, Azure) * Security and compliance features (e.g., encryption, access controls) On-Prem Client: * Quivr Agent * Programming Language: C# or C++ * Framework: Windows Desktop (.NET Framework or .NET Core) or macOS (Xamarin or macOS SDK) * Da...
I'm looking for an experienced developer to a piece of software for my jewellery repair business. I do work for several stores and they each send me multiple jobs per week. Some of these jobs are ok to just do, however some require quotes/estimates. I need software that will let my customers log in to a portal and view and be able to proceed/decline and comment on each individual estimate. I would like them to get notified of each estimate to their email and also for my email to be notified whenever they proceed/decline or comment on an estimate Key Requirements: - The software could be designed primarily for use on the web or an app - The main purpose of the software is allow customers to each have there own portal where jobs can be viewed and any proceed or comments will be s...
I'm in need of an administrative assistant who is proficient in Microsoft Excel for data entry and updating tasks. Specifically, this role entails managing my product inventory. Your primary responsibilities would involve: - Entering and updating inventory data on a regular basis - Organizing and ensuring the accuracy of each entry - Handling large data sets in Microsoft Excel - Following-up to make sure if the items in the inventory is still available It would be beneficial if you're detail-oriented and have prior experience in this kind of work. Don't hesitate if you have questions. Looking forward to your bids.
I am in need of a Python expert to create a program that will handle multiple tasks concurrently via workers (multi process) I already wrote a task manager using threading and async, I just want to make sure I have no race conditions, avoid deadlocks and improve logic and preformance.
I need a basic template that modifies the existing Chart Trader Panel buttons. Basically, I just want all of the top Buttons to disappear, except the Close Button. Also the Bid and Ask display to be hidden. ===================== All buttons should re appear when the strategy is disabled. Also if we have multiple tabs with different charts. The buttons should only disappear on the tab where the strategy is enabled. The Close button, I just want it to be 1 big button if possible
...com/documentation/api/practice-manager-3-1/staff - Jobs & Tasks - - Time - - 1 x Document Set for Clients, and 1 x Document Set for Jobs that are sync'd with the Clients and Jobs lists (e.g. New Client = Setup New Document Set) The lists above are linked so I want to columns to link to the appropriate list (e.g. Clients to their respective jobs). I won't be able to share the API key with you because of sensitive data however you can use the sample responses provided on the XPM site to design the power automate flows and SharePoint site. Once done, I can import into my environment as I have already setup the custom connectors. Ideal candidates for this project would
configure haproxy with my VPS (digital ocean) - I have multiple applications - vue and django - for development Request: - configure domains and subdomains for applications - link domains wiht docker services or containers - configure Lets enctypt certificate
I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your relevant experience and any sample work you've done in the pa...
...DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns] = useState({ column1: { id: 'column1', items: ['Sample_Step1', 'Sample_Step2'] }, column2: { id: 'column2', items: [] }, column3: { id: 'column3', items: ['Sample_Step6', 'Sample_Step7'] }, }); const tableData = [ { step: 'Sample_Step1', stepNum: '1', data: 'Enter Text' }, { step: 'Sample_Step2', stepNum: '2', data: 'Click Button' }, // ... add more data rows here ]; // const handleDragEnd = (result) => { // // ... logic to move items ...
...Development of AI bot for a multi-functional purpose including customer support, data analysis, and voice recognition - Design a simple and minimalistic user interface - Ensure the bot's smooth and efficient performance - Integrate the bot into the desired platform (website, mobile app, or desktop application) Ideal Skills and Experience: - Proven experience in developing AI bots, especially for multiple tasks - Strong understanding of customer support systems, data analysis, and voice recognition technology - UI/UX design skills to create a simple and minimalistic interface - Proficiency in integrating the bot into different platforms - Excellent problem-solving and communication skills If you have the skills and experience in the aforementioned areas, I'd like to...
...showcasing and selling products, so it needs to be user-friendly, efficient and secure. Key Project Requirements: - The website needs to support 100-500 products. - The primary payment methods we're looking to integrate are Credit/Debit cards, and a custom payment system. Ideal Skills and Experience: - Prior experience with large e-commerce website development - Proficiency in integrating multiple payment gateways into a website - Strong understanding of user experience and security protocols - Ability to design a system that can manage our physical and online inventory effectively - Expertise in vue js, react js, tailwing css, php, core php, mysql, aws, laravel and bagisto If you have a track record in building scalable e-commerce platforms with similar requirements, ...
I have a requirement for someone well versed in Excel formulas and calculations, specifically with respect to tracking approaching dates. The main objective is to monitor upcoming deadlines. Ideal candidates should have: - Proficiency in Excel calculations and conditional formatting - Expertise in implementing algorithms to track deadlines - Strong attention to detail - Previous experience in project tracking or similar Your role would involve setting up the necessary formulas and conditional formatting to efficiently track these dates. Understanding the importance and urgency of deadlines, your input would greatly assist in managing our tasks better.
I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please ...
I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored
I'm in need of a logo to represent my brand across various platforms - website, business cards, social media, as well as on shirts and hats. My business industry is pressure washing, and I would like the logo be the name X7 Softwash, and it surrounded by elements relevant to pressure washing. I have attached a ChatGPT generated logo as a generalized concept, however it is not exactly what I'm looking for, but instead only a rough idea as to how it could look. - The only words in the logo are X7 Softwash - The colors are Blue, White and Black. - Water, Water drops, Bubbles and a pressure washer wand spraying water, would be ideal for elements. - I can spot an AI generated logo a mile away, so feel free to use that for inspiration, but not the final project. - The logo needs to...
...Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on the job. Single or multiple employees may work on one job with the ability to add 'batches' of labour hours as and when the job is worked on. These hours must then be totaled on completion. - Ability to edit / create job cards on-site through iOS App or web-based form. Some employees are workshop based, others are mobile. - Ability to select a simple job status from a drop-down combo box eg. In-p...
Project Description: I need a developer to create a system that queries multiple external sources (18) through APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log...
...freelancing website and I am seeking a skilled graphic designer to create a unique and professional logo that embodies the essence of my platform. My vision for the logo is minimalistic, hence I prefer a design that is clean, simple, and modern. Additionally, I would like the color scheme to be cool tones, mainly focusing on blues and greens. The ideal logo should be versatile and suitable for multiple applications. It should be able to be used on business cards and print materials, as well as across all digital platforms such as social media and email signatures. Skills and Experience: - Proven experience in logo design, especially in minimalistic styles - Strong understanding of color theory and the ability to work within a specified color palette - Prior experience in desi...
I'm in need of a Progressive Web Application (PWA) for collecting survey responses towards an onboarding process. The application will feature: - A mixed set of survey questions, including both multiple choice and open-ended questions. - Responses will be sent to a Google Sheet for easy management. - Integration with a payment gateway after the survey for users to proceed with payment. - Survey responses should not be anonymous. The ideal freelancer for this project should have experience in developing Progressive Web Applications (PWAs) and integrating them with Google Sheets and online payment gateways. They should also be able to implement a mixed survey layout and ensure that the survey responses are not anonymous.
Search for commercial loan officers on linkedin and fetch contact First and Last name, bank name, cell number or direct work number i need working direct number only one not multiple The counties are in: Citrus Hernando Sumter Pasco Hillsborough Pinellas Lake Polk Orange
...buttons to redirect to the online ordering page - Change "Credits" to "Contact: Business: (Name, Last Name, Email, and Phone); Press: (Name, Last Name, Email); Complaints: (Email)" - Change "Jesse Ramen" or "J Zhou" to "[Brand Name]" - Change "Ramen" to "[Brand Name]" Booth/Kiosk: - Change the wood texture to a metal texture reminiscent of a New York-style hot dog cart - Remove the Chinese flyers - Place some sauce pots on the counter - Integrate our logo with 3D neon - Change the "Best Ramen in Town" image to our image Menu: - Create a menu in Three JS according to what we offer Update branding and design elements to align with our company's identity, se...
