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 Mar 14, 2020
Winata Winata
from Veracruz, Mexico

Skills & Expertise Required

Excel

Open for hiringApply before - Aug 22, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$5.75

Cost

Offer to work on this project closes in 104 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

Listing expensive art online on the popular art selling websites - Fixed
Business Card Data Entry--Scan or type in business cards for me - Hourly
React Native Developer - Fixed
Vtiger CRM Expert/Developer - Hourly
want to an android app - Fixed
Website Marketing and Development. - Fixed
Web scraping - Fixed
Dexi.io Web Scraper with Azure Function in PHP - Fixed
LinkedIn API - Query Content of groups - Fixed
Levitate MMA Supply Co. -- Minimal LOGO NEEDED - Fixed

Similar Projects

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

Develop Power BI Dashboard

Ill like to create a dashboard heat in Power BI to display information. More details will be provided. But basically the row will show the projects and their names, the column will show variables that the project will be rated against based on green...read more

Database Cleanse

We have a database of around 50.000 contacts, very sensitive information that includes email addresses, however there are contacts without name or without address, phone numbers differ in format, some of them without a country, etc

The main...read more

Develop Smartsheets Dashboard

Ill like to create an Excel dashboard heat to display information. More details will be provided. But basically the row will show the projects and their names, the column will show variables that the project will be rated against based on green red...read more