Завершено

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.

Квалификация: Ввод данных, Обработка данных, Excel, Транскрипция, Word

Показать больше 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

О работодателе:
( 128 отзыв(-а, -ов) ) Ottawa, Canada

ID проекта: #18892099

Поручен:

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 Больше

$60 USD за 3 дней(-я)
(32 отзывов(-а))
4.9

33 фрилансеров(-а) в среднем готовы выполнить эту работу за $131

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 ( Больше

$222 USD за 2 дней(-я)
(672 отзывов(-а))
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. Больше

$160 USD за 3 дней(-я)
(310 отзывов(-а))
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 Больше

$150 USD за 0 дней(-я)
(841 отзывов(-а))
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 за 3 дней(-я)
(285 отзывов(-а))
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 Больше

$30 USD за 0 дней(-я)
(170 отзывов(-а))
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 Больше

$180 USD за 2 дней(-я)
(92 отзывов(-а))
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 за 3 дней(-я)
(90 отзывов(-а))
6.1
MohsanEijaz

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

$155 USD за 3 дней(-я)
(74 отзывов(-а))
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 за 5 дней(-я)
(198 отзывов(-а))
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 Больше

$155 USD за 3 дней(-я)
(34 отзывов(-а))
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] Больше

$155 USD за 3 дней(-я)
(7 отзывов(-а))
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 за 3 дней(-я)
(8 отзывов(-а))
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, Больше

$155 USD за 3 дней(-я)
(9 отзывов(-а))
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 Больше

$100 USD за 1 день
(10 отзывов(-а))
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 за 3 дней(-я)
(8 отзывов(-а))
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 Больше

$155 USD за 3 дней(-я)
(9 отзывов(-а))
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 Больше

$111 USD за 1 день
(2 отзывов(-а))
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 Больше

$30 USD за 1 день
(1 отзыв)
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 Больше

$30 USD за 1 день
(1 отзыв)
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 за 3 дней(-я)
(0 отзывов(-а))
0.0