Filter my excel sheet
- or -
Post a project like this18
£10(approx. $13)
- Posted:
- Proposals: 10
- Remote
- #4176741
- Awarded
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |
San Jose
Logo & Graphic Designer / illustration / PowerPoint / CAD / AI Expert / Web Designer
Rawalpindi
Data Consultant (Expert in Excel, VBA/Macros, Google Sheets, Fillable Pdf services, Data Entry)
Zwota
1497060546363431416354499241753816608173702681797604631101394411038164
Description
Experience Level: Entry
I have an excel database of 300k entries. I want to filter and remove any entry that is not a full first name or is a blank cell in the first name field.
For example there are lots of entries that say 'First Name' = A or 'First Name' = BLANK
I want to be left with my spreadsheet having full First Names only and also removing all blanks.
I also want my 300k entries to be split into 50k files (x6) per document.
I hope this is clear.
For example there are lots of entries that say 'First Name' = A or 'First Name' = BLANK
I want to be left with my spreadsheet having full First Names only and also removing all blanks.
I also want my 300k entries to be split into 50k files (x6) per document.
I hope this is clear.
Nathan B.
100% (14)Projects Completed
15
Freelancers worked with
14
Projects awarded
26%
Last project
20 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies