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
Sanjay Phadtare
from California, United States

Skills & Expertise Required

Excel 
Open for hiringApply before - Sep 11, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$5.75

Cost

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

Looking for art to serve as a overlay for my video streaming project - Fixed
Graphic Designer Needed for Brand Standards - Hourly
Call to Amazon seller suport - Fixed
Graphic Designer wanted for Children's eBooks. (Long-Term) - Fixed
New Detailed Website Specifications and Wire frames for site and mobile app - Fixed
Real Estate acquisition and Foreclosure Research US North-East - Hourly
Shopify Re-design - Hourly
Book printer - Fixed
Translation english to Norwegian - Hourly
Need a cyber security course content designer from basic to advance - Hourly
Immediate need - Graphic designer(s) strong on photoshop and illustrator - Hourly

Similar Projects

Microsoft Specialist Wanted

I am looking for a well-versed tech assistant with strong proficiency in Microsoft Word, Excel, PPT and Access to help us process a few work, including designing slides, creating database and polishing forms, etc.

Ideal candidates must be...read more

Convert our excel workout program into an interactive locked data sheet

We have an excel sheet from a world reknowned weight lifter and professional powerlifter that we would like to productize and sell as a info product.

In doing so, we need to convert the excel sheet into either an interactive PDF or interact...read more

Optimization of an Excel file

I have a data base in excel with a lot of linked tables. I need someone who can add some more formulas in order to automate calculations in big tables.

I will provide all required details in the chat. Thanks in advance!

Excel / Google sheets Expert for multiple projects ( E commerce experience needed)

Hi

I am looking for an expert Excel / google sheet expert who can create complex eCommerce data sheets which involve all details and also linking to other sheets to grab data
we are finding hard time to get track of our sales / ROI and p...read more

Need to make a user form in Excel

Need to create a data entry form with a specific design and 2-3 buttons

Submit A Proposal