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.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Transcrição, Word

Veja mais: 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

Acerca do Empregador:
( 128 comentários ) Ottawa, Canada

ID do Projeto: #18892099

Concedido a:


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 Mais

$60 USD em 3 dias
(32 Comentários)

33 freelancers estão ofertando em média $131 para esse trabalho


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 and have been featured by the freelancer community ( Mais

$222 USD in 2 dias
(672 Comentários)

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. Mais

$160 USD in 3 dias
(310 Comentários)

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 Mais

$150 USD in 0 dias
(841 Comentários)

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 dias
(285 Comentários)

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 Mais

$30 USD in 0 dias
(170 Comentários)

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 Mais

$180 USD in 2 dias
(92 Comentários)

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 dias
(90 Comentários)

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

$155 USD in 3 dias
(74 Comentários)

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 dias
(198 Comentários)

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 Mais

$155 USD in 3 dias
(34 Comentários)

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] Mais

$155 USD in 3 dias
(7 Comentários)

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 dias
(8 Comentários)

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, Mais

$155 USD in 3 dias
(9 Comentários)

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 Mais

$100 USD em 1 dia
(10 Comentários)

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 dias
(8 Comentários)

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 Mais

$155 USD in 3 dias
(9 Comentários)

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 Mais

$111 USD em 1 dia
(2 Comentários)

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 Mais

$30 USD em 1 dia
(1 Comentário)

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 Mais

$30 USD em 1 dia
(1 Comentário)

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 dias
(0 Comentários)