Completed

Need Excel help (filtering large data file)

I'm looking for an Excel expert to do a few things to my spreadsheet, and to explain to me how you did it (so I can learn).

Note: I use Excel for Mac (version 16.6.7)

I have a large Excel file (~7 mbs, ~74,000 rows). The file contains many different web page URLs, along with SEO metrics (e.g. domain rating, organic traffic, etc) for each URL.

I need help doing these three things with the file:

1) Filtering the master sheet by criteria for two columns, then automatically transferring the filtered data into a second (new) sheet

2) From the second sheet, automatically copying and pasting rows that contain specific data (unique instances of URLs) into another (third) sheet

3) In the third sheet, automatically removing characters from cells (specifically, removing the web page extension from each URL, so only the root domain URL is left).

I would like the freelancer I hire to do two things: (1) do the work in my Excel file (if that would include writing macros to do the work, that would be fine); and (2) tell me (or show me by recording a screencast) how you did the work, so I can do it myself on other sheets.

I can share the spreadsheet and a quick video showing exactly what I want done. PM me if you're interested.

I'm willing to pay a good fee to an Excel expert who can get this done AND explain to me how they did it.

Interested bidders MUST briefly explain what makes them an Excel expert.

Skills: Data Entry, Data Processing, Excel, Transcription, Word

See more: excel filter function, dynamic filter excel, how to filter data in excel using formula, how to use advanced filter in excel, excel filter multiple values, how to filter multiple columns in excel, how to filter rows in excel, advanced filter excel 2016, excel large data files, adonet sql large data excel export, need upload large audio file, need web scraper takes search data excel, excel script copy cell data closed file, need excel file track job, excel vba create data file, need excel macro input data, excel macro input large amount data, write xml data file using excel vba, parse large csv file information need, exporte excel asp large data

About the Employer:
( 128 reviews ) Ottawa, Canada

Project ID: #18892099

Awarded to:

ilkecokay

Hello sir. I can help you with your projects and prepare screen recording videos for you (narrated by me) to help you with your excel work. I have a long history with Excel VBA and i think that is what makes me an expe More

$60 USD in 3 days
(32 Reviews)
4.9

33 freelancers are bidding on average $131 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$222 USD in 2 days
(672 Reviews)
8.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$160 USD in 3 days
(310 Reviews)
7.8
cgullapalli

Hi, I am good at Excel and VBA. I would like to review the existing code and update the necessary points as mentioned. I will work on your mac via screen share. And i will explain the process. Looking forward More

$150 USD in 0 days
(841 Reviews)
7.9
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD in 3 days
(285 Reviews)
7.2
datakillers

Hi, I can do this virtually directly on your PC view team viewer I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You ca More

$30 USD in 0 days
(170 Reviews)
6.8
sunmoon25

Hi Here is excel expert. I have read the project description and I ensure to filter 74 k data file accurate filtering. Before start the work, I will show you sample first. Please contact with me for discussion. Tha More

$180 USD in 2 days
(92 Reviews)
6.5
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure. Willing to take up your project. Thank you, Regards.

$155 USD in 3 days
(90 Reviews)
6.1
MohsanEijaz

I have experience of vba, I can do this task easily. Mohsan

$155 USD in 3 days
(74 Reviews)
6.2
sparkingboy2010

Hi, I'm an expert in Data Entry and excel. I understood your all requirements. I have done many projects like this. I'm ready to start now. Regards, Noor

$200 USD in 5 days
(198 Reviews)
6.3
lightingdavid

Hello. How are you? I am highly interested to work on the "Need Excel help (filtering large data file)". I am a full stack website developer. I have more than 7 years experience in "Data Entry, Data Processing, Exc More

$155 USD in 3 days
(34 Reviews)
5.4
khanjzthanjzt

Greetings, We have read the project description an understand the nature of work. Allow us to complete this project within deadline with 100% accuracy and perfection. Warmest Regards Sample Work [login to view URL] More

$155 USD in 3 days
(7 Reviews)
4.4
avennhossain

Hello Sir I have a team. My team is always active for work. If you give me a chance and give direction for the job, I will do this. Regard's Blood Freelancer Team

$155 USD in 3 days
(8 Reviews)
4.3
OutsourceMan

We are in the top 4% of freelancers based on our earnings and reviews. We specialize in: Plugin MySQL WooCommerce eCommerce Javascript and others. Please see this for proof: [login to view URL] Hello, More

$155 USD in 3 days
(9 Reviews)
4.4
shahinrahimi

I can help you, I would refer you to my reviews. I have rich experience in excel and VB, and I do my best to save your time and pocket. I can assure you the results and help you done this on your own. plz feel free to More

$100 USD in 1 day
(10 Reviews)
3.3
hsingla85

Available Immediately | MS Excel and VBA Expert | Assured quality of the work and timed delivery | You can check my jobs history for the same. Looking forward for your message.

$111 USD in 3 days
(8 Reviews)
3.3
AFTAB2017

Hi, I read with interest your posting. I got your job requirements and can start immediately. I believe I possess the necessary skills and experience you are seeking and would make a valuable addition to your compan More

$155 USD in 3 days
(9 Reviews)
3.0
sumitbhati40

Hi, I would love to work on your project. I have a Masters of Computers (MCA). I am Excel Expert by profession. I have 13+ years of exp. working on large excel sheets database with companies like Vodafone, India Bulls More

$111 USD in 1 day
(2 Reviews)
1.8
mehranica

I am quite familiar with Excel. Your project can be done both using VBA and also Excel formulas such as VLOOKUP, FIND, LEFT and RIGHT. I suggest you use the formulas because updating it is easier. Your project will be More

$30 USD in 1 day
(1 Review)
0.5
Sakibul100

Hello dear I'm interested in this project. I'm a professional Data Entry specialist. I already completed the 200+ project in this work. I'll provide Pro Work. If you do not like my work, then 100% money back. Wish you More

$30 USD in 1 day
(1 Review)
0.5
Andrewgad8

I am sure I will make your project perfectly, I can make an example for free; If you like it I will make the remaining part of your project.

$155 USD in 3 days
(0 Reviews)
0.0