Remote Network And System Administration Job In IT And Networking

excel formula to highlight duplicates

Find more Network And System Administration remote jobs posted recently Worldwide

I have a large excel file (70,000) with email addresses. I have 1000 or so bad emails. I want a formula that will help me remove the bad emails.

Currently I have a formula that involves putting the bad emails at the end of the email column, sorting them all in alphabetical order so that the duplicates are together and then making an empty column and using the formula to put an x in the new column beside the duplicate.

this is so time consuming

I want a formula that will just identify the duplicates and put an x in the new column without me having to sort them all in order first
About the recuiter
Member since Nov 11, 2022
Allen Frankh
from Hessen, Germany

Skills & Expertise Required

Excel

Open for hiringApply before - May 31, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$5.75

Cost

Offer to work on this project closes in 16 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Need someone who can draft a service retainer proposal and agreement - Hourly
WordPress Installation and Customization - Hourly
Wix expert needed for setting up members pages and other advanced features - Hourly
Comic book artist for graphic novel - Fixed
Fix code for Visual Studio App - Hourly
Restaurant Exterior Modeling - Hourly
I want someone to design a laptop motherboard for me - Fixed
Landscape design including pool plan - Hourly
MS admin needed to run old software on new 2016 server. - Hourly
Embed 3rd party applications in existing Ruby on Rails Project - Fixed
Web Designer needed for improving b2b website - Hourly
Machine Designing - Fixed
Zendesk expert - Hourly
simple webpage transformation into Wordpress/Joomla plus style improvement - Fixed
Accountant to Search for Companies using Creditchecking Software - Hourly

Similar Projects

EXCEL POWER QUERY MANIPULATION

I have an excel data table that i need manipulating (ideally via Excels Power Query).

As youll see in the picture the first column is CODE. that will always be called CODE and will always be the first column.

we then have a repeati...read more

Need to build an .XL spreadsheet / dashboard for account audit

Need to build an .xl dashboard / spreadsheet for auditing customer accounts.
There are 14 different criteria. Each criteria needs to have a values field, a comments field and an action plan. The 14 criteria are
1. Quality and On Time (va...read more

Excel data mining

The easiest thing is to show you my project in Cisco Webex to be able to explain what I need assistance (there are multiple areas) and see where I could get your help.

Thanks

Google Sheets Expert

We are creating online courses and as part of the course we want to ask members to fill in an audit document which asks them questions about their business at the end of each module (6 modules). Their answers from each module would then go into an Ac...read more

Microsoft SQL Server and Access Developer needed

I need someone that is proficient in VBA for Access and Excel. The person also must also have experience in writing SQL code and installing SQL Server express edition on a server and make the database visible via odbc connections on clients machine...read more