Excel remove duplicate rows based on one column işler

I'm seeking an Excel expert who can design and build an org chart that visualizes my company's structure. The primary requirements of the project are: - Creating an innovative org chart with 5 to 10 levels of hierarchy. This should lucidly identify reporting relationships and aid in future workforce planning. - Chart must be dynamic and editable, allowing easy updates when there are organizational changes or expansions. Ideal candidates for this project should demonstrate: - Proficient knowledge and experience with Excel. - Previous examples of detailed, dynamic org charts created in Excel. - Strong understanding of organizational structures and how to best represent them visually. - Excellent attention to detail and accuracy.

I want to edit a photo (photo 1) of a bedroom showing a green queen bed frame with wooden slats to remove/erase that bedframe including head and replace it with another solid one piece bed base (photo 2). This needs to look like the photo has not been touch. Completion of the job will not be accepted if a naked eye can detect that the photo has been touch i.e. signs of blur, perspective not right etc. it has to look like a photo was just taken with that other bed base. More photos available of the new bed base here:

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

I'm seeking a talented graphic designer who can bring a musician to life on a music cover. Your experience with illustrating artists in an engaging and dynamic fashion is key here. - Focus: The cover art should primarily feature a musician/artiste, take a creative liberty to select an aesthetic that you think will complement the musician's personality and music style. Given the skipped questions, flexibility and a wide range of artistic skill will be appreciated. Openness to iteration and revision in response to feedback is also important. - Skills: Graphic Design, Illustration, Creativity, Flexibility Take this opportunity to create a captivating musician-based cover art piece which will be at the forefront of the music. Looking forward to seeing your creat...

For this project, I need a skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, a...shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency in working with Excel data is necessary. Detailed requirements and design specifics will be shared upon commen...

As the owner of an HTML based website, I need a professional with proficient skills in HTML, CSS, and Bootstrap to replace the existing content. Ideal skills and experience: - Profound knowledge of HTML, CSS and Bootstrap - Previous experiences with content transfers - Excellent attention to detail to ensure accurate transfer Project Tasks Create new page from contents H1, H2, H3 Titles given with the tag into contents so you will know what title where to put Need to create images from canva or any other tools simple related to paragraph Alt tag in image must be pasted whenever required Images must be compress with tiny png Code with minimal tags Contents will be from 1500 words to 3500 words Just copy from existing page code and replace text and images if needed create new...

...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...

Looking for skilled UI/UX designers residing in India to assist my US-based company. The ideal candidate should have experience in user interface and user experience design. Key Responsibilities: - Designing user interfaces - Enhancing user experience Preferences & Requirements: - The work should align with our specific preferences which will be discussed upon hiring - Must incorporate our company logo into the designs It's a plus if you have previously worked on Figma project. Please refer to this Figma project URL for reference: GvZvFLYbc8oIphVv-1. Looking forward to your creative applications!

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I need a freelancer to duplicate my existing e-commerce platform. You will be primarily focusing on replicating the design and layout of the website. Key responsibilities include: - Identifying distinct features of the current layout and designing a new website following these specifics - Ensuring the design and layout of the new website mirror the existing one - Providing innovative suggestions and ideas for possible improvements The ideal candidate will have a wealth of experience in e-commerce site development, possessing strong attention to detail, and a keen eye for design. Proficiency in relevant web design tools and software is a must. While the emphasis is on duplication, creative input is welcomed for effective user interface and overall aesthetic...

Logo needed for brand offering Tow Service Designs should include iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Two Bit Tow << "Two" should always be written out (not 2) "Bit" refers to coin(s) > Brand Colors are Black, White, and Red > The design should be effective with and without color > The design should be effective with and without enhancements > The design should be recognizable even at small sizes > Designs with contrasting elements which lead the eye toward the center of the icon are ...

...build a web scraper to extract data from a map-based website. Here's a high-level rundown of the project: - Develop a Python scraper that can pull geographic coordinates from a map-centric site. - Clean and organize this data so it can be exported in CSV format. - The script must be well-structured and well-documented for future reference or modification. Your skills and experience: - Proficient in Python, with a deep understanding of web scraping practices. - Knowledge of various data structures and understanding of handling data in CSV format. - Experience with GIS, map data, and geographic coordinates would be a significant plus. - Prior experience with large-scale data extraction projects. Detailed requirements (including the specific map-based website) will be...

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A sprea...have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity wit...

I'm seeking a skilled developer to create a web-based application that can offer grade calculation and assignment management functionalities. This is a multi-user platform intended to assist several teachers at once, fostering an easier educational management process. Key Features: - Grade Calculation: The app should be capable will calculating grades based on the inputs provided by teachers. - Tracks v9 of the Australian Curriculum ENGLISH over years. (See attachment) - Assignment Management: Teachers should be able to assign, track, and manage assignments. - Must be very clean and intuititve, use with touch screens. - Google / apple clean interface. Ideal Skills: - Proficiency in web application development. - Prior experience with education apps or similar ...

I'm in need of a professional structural engineer with a prime focus on residential buildings. The primary task features the comprehensive design of the structure. The successful freelancer should be able to provide: - Proven experience in designing residential structures - Exceptional knowledge in compliance with building codes - Excellent design skills, maintaining the integrity and safety of the structure This is focused on concrete column, beam, post tensioned cast in place concrete. Standard dimensions length and width will be in the 35 to 40 feet for routine stressing of tendons. The cast in place will be within a stay in place precast concrete wall system, which serves as the finished wall service, exterior and interior. Most standard material...

Need to covert selenium script to selenium base and need to work on these: 1. Multiple instance from same pc 2. Proxy should be authentication base 3. random useragent if necessary 4. random user profiles need to remove 5. select store

Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities

Hi, i need somene create an Ai automation bot which follow by different msg from telegram group and open order in my trading accounts? Which mean follow by few telegram group msg and open trade follow by the pairs and numbers and also stop loss and take profit too, but then I would like the take profit and stop loss wouldn’t inside the broker panel there and follow the numbers like human and execute it. If you not understand anything and we will discuss more so I can let you understand more, my budget and timeline will be 110 usd and 14 days to be done and no other hidden charges or outside charges. And also pls let me know soon if you can do it as I have ask few seller in here too, hope to see your reply soon, thank you.

...proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be shared dur...

I'm seeking a professional with experience in baby nutrition and meal planning. Ideally, you will assist me in creating inventive, tasty, and nutritious fruit-based recipes that would suit a baby aged 9-12 months. These recipes should primarily focus on apples and bananas, yet can include other fruits suited to this age range. The successful applicant will have understanding of babies' nutritional needs, especially for those transitioning to solids. Track record in creating healthy, appetising meals for infants is required. A background in dietetics or nutrition will be a big plus.

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

...Sheets and ChatGPT to create a system where column A holds factual statements, and column B generates a unique ChatGPT response based on the statement in column A. The prompt will remain constant, with only the input from column A changing the outcome. Ideal Skills: - Google Sheets proficiency - Experience with OpenAI's ChatGPT or similar AI based conversation models - Strong understanding of how to integrate API-based response generators into spreadsheets - Ability to execute tasks seamlessly without creating duplicates or errors. Experience: - Past projects involving integration of AI chat models and spreadsheet software will be advantageous. Note: There is no need for verification of the uniqueness of responses, so yo...

...discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. To excel in this role, you'll need to work approximately 6 hours a day, 6 days a week. This schedule is designed to ensure continuity in my operations while allowing flexibility for you. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. Your ability to harness the full potential of these tools is crucial. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential...

...section, my requests will be listed below. FRONT END - The ready Html5 design will be worked on - We will be able to control and change every part of the front end page from the administration panel. - When you enter the content of the product, there will be size options and the prices of the selected sizes will be shown. If there is no size, it will only show the price of the main product. - When you enter the content of the product, there will be a Description and Specification section at the bottom. - We will be able to add the site language, you just need to use standard English and we will add other languages. - When necessary, we will be able to cancel the Add to cart or buy button on the products we want, or we will be able to select and cancel in bulk. - ...

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essenc...

Hi everyone, I will need a computer network analyst (ideally with cisco certification) with experience in measuring network delays, calculate jitter (with tools povided), do some graphs in excel etc. Analytical specific requirements in chat Deadline: 4/4 Budget: $20 USD

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of ...

I need 10 hero images + 10 royalty free images for each hero images. include the fonts and design files. Send proof of royalty free? Hero Images: 1) remove navigation menu-Home, About Us, Services, Blog, Contact Us, 2) remove “Get Started” buttons and the word “logo” 3) remove sub head: Sporting Goods, Camping/Hiking, Water sports, DIY/Crafts, Tools and other Hobbies! Except for the hero image labeled “All” Images- replace images specified in chat.

I'm in need of an experienced Python developer capable of implementing a machine learning model API as swiftly as possible. Specific skill-set and experience that I'm looking for: - Strong expertise in Python - Deep understanding of API development - Experience in Machine Learning - The ability to implement the project promptly and efficiently I haven't selected a preferred ML framework yet, and I'm open to professional suggestions during development. Your ability to deliver high-quality work within the shortest time frame possible is greatly appreciated.

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

I am looking for an experienced Python developer to develop a Windows desktop application. This project will involve content writing and SQL as key components. The ideal freelancer for this role should have: - Expertise coding with Python - Familiarity with creating Windows desktop applications - Extensive knowledge in SQL and content writing Primary functionality of the application should include: - User Interaction - Networking Communication Within the data processing functionality, the following areas are required: - Data analysis and reporting - Data manipulation and transformation - Data storage and retrieval In order to ensure the application fits its purpose, clear abstracts and documentation will be imperative. The freelancer should be experienced in writing clear, concise, ...

I'm seeking a talented graphic designer to create a new logo for my coaching business. This logo needs to be text-based with certain design and color preferences: - The logo should predominantly feature blue, black, and white. - For the font, I want something bold to stand out. - I'd also like to incorporate circles into the design to make it distinct and memorable. (think of the icon) - Feel free to use lines also (but think about the icon square) Name: Improv For Change (IFC) Colors: Navy Blue (prominent) Black & White (optional) Would like to see the Icon (IFC) and the text logo separate AND together. Ideal candidates for this job have experience in logo design, a great eye for design style, and the ability to create unique professional designs.

Hello I have excel file with many products link in side by side and product serial number in column 1 can you make alll links into rows as per there respective serial number?

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

...need to integrate this functionality with our existing PHP-based website. Below will be the work flow for project Step 1: Implement a button on a PHP-based website labeled 'Import Bills'. When clicked, it triggers the import process. Step 2: Upon clicking the 'Import Bills' button, provide a browse option allowing the user to select the bill image from their disk. Step 3: Utilize an OCR (Optical Character Recognition) plugin to extract data from the selected image. This extracted data is then compared with existing data in the PostgreSQL database. A popup will display the mapped data and additional information. Unmapped data will require user intervention for mapping. Step 4: The bill image may have variable column structur...

...network: digital format for phone to send to customers with less percentage of art in the design and another to print in a book with a bigger % of the page in cool design leather cover engraved with a cool cover design Saying Gran casa santiago services and a design of your liking for the leather cover and 2 pictures with all information condensed to post on airbnb photo listings this has a spanish version and english version, use english for example in entries I would like a menu that reflects the jungle style but modern techy property i have 8-10 pages max for book menu and 3-5 pages for phone menu vertical and only 2 pages for airbnb photos (really condensed info and clear to read with a slight jungle touch) Quiero un menú para un hotel boutique

I'm in need of an experienced WordPress developer to create a user-friendly, informational website that educates visitors about my company Key Requirements: - Develop a website with 1-5 pages. - Include Articles, Images, Videos, and Interactive Forms for rich content. - Create a visually appealing and easy to navigate interface. Ideal Skills & Experience: - Strong Background in WordPress development - Experience with creating rich content websites - Knowledge of modern UX/UI principles - Proficiency in HTML, CSS, JavaScript, PHP - Previous experience in developing informational websites.

I'm in need of an experienced AI developer who can build a generative AI application for the web. The purpose of...purpose of the program is to automatically generate written content specifically tailored towards human resource professionals. Key Project Deliverables: * A well developed and fully functional web-based Generative AI application * The AI must be capable of creating highly professional and useful content for HR professionals The ideal candidate for this job should have: * Provable expertise in AI programming, particularly in Generative AI * A great understanding of how to create web and smart phone apps * Excellent web development skills * Past experience in similar projects. A well-done job on this project can lead to future work as we expand the func...

I need a skilled WordPress developer, with experience in Bookly Plugin customization, to modify my invoice form with an additional drop-down column showing payment method options. This drop-down column should include but not be limited to: PayNow, HitPay, and Bank Transfer. A deep understanding of payment integration is vital for this role. The goal is to provide a range of payment options for the convenience of our users. The freelancer should also have a keen attention to detail to ensure the changes seamlessly fit with the established design and functionality.

...activity 2) Send Push Notifications 3) Add/Edit/Remove quiz databank - for each question, manage type, category, difficulty level etc. 4) Manage users 5) Manage badge and point system 6) Manage main app screen educational content The gamification will require: 1) On Demand quizzes - utilizing the question bank 2) Compete quizzes - where users can challenge other users can challenge others for 1:1 or multiple-user quiz game, up to 20 users (when other users have allowed competitions) 3) Leaderboard - weekly / monthly by Country 4) Award points for taking on-demand and compete quizzes 5) Award points for winning 1,2,3 positions in compete quizzes 6) Award badges for different actions taken - also manage badge system where admin could add/remove/edit new ba...

I need a basic bollinger band based strategy but since I can't check all charts during intraday, it needs to scan 50 to 100 stocks and show only those which satisfy the condition of our strategy. Check attachment for some understanding. The strategy is on a 5 minutes time frame (TF) but for confirmation, we also check higher TF. If both are satisfied, then signal must be generated in lower TF with target and SL. Ideal Skills: - Proficiency in Pine Script - Experience with TradingView and Bollinger Bands - Stock market understanding

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I ...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

I am seeking a freelancer skilled at Keynote and graphics to convert a PNG image into a Keynote slide. For this project, the main objective would be creating the format so I can use as a template. Remove the text and draw the grid and boxes. . Ideal candidates would have: - Profound experience in Keynote and graphic design. - Knowledge in PNG formats and their best use in Keynote. - The ability to effectively highlight and integrate text from an image into a slide's design. - Excellent attention to detail, to ensure no important aspect of the template is left out.

Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.