Zamknięty

excel sheet data bifurcation

I have a excel sheet of companies data. It has columns like Company Activity Word.

Now I have such 4,12,718 rows but the data is repetitive. I wanted to extract only unique activity words out of them,

For example: 1) AGRI AND DAIRY FARM

2) AGRI AND DAIRY FARMS

3) AGRI AND DAIRY PRODUCTS

4) AGRI AND DAIRY PRODUCTS INDIA

For all of the above mentioned names we can assign only one name as AGRI AND DAIRY FARM or I will tell what to assign. Also it will be self explanatory to think about such common names.

So the task is to extract Unique names from given sheet.

Umiejętności: Wprowadzanie danych, Eksploracja danych, Przetwarzanie danych, Excel, Pozyskiwanie danych z Internetu

Zobacz więcej: excel sheet data, excel sheet data macro, excel sheet data extraction pdf vba, how to split data into multiple files based on column in excel, split data in excel into separate worksheets, split excel file into multiple files by row, split excel sheet into multiple files based on column, excel split data into multiple sheets, how to split one excel sheet into multiple files, how to split data into multiple workbooks based on column in excel, split data into multiple worksheets excel 2007, data entry, data processing, excel, web scraping, data mining, microsoft access, simply excel sheet data, excel sheet data database, sample inventory excel sheet data

O pracodawcy:
( 0 ocen ) India

Numer ID Projektu: #17400784

94 freelancerów złożyło ofertę na kwotę ₹5163 do tego projektu

₹7800 INR w ciągu 1 dnia
(254 Oceny)
7.6
jdurio

Hi, i'm an expert in cleaning Excel data. To find unique Company Activity Words for you, this is what I propose: I review the list and come up with 10-20 "text cleaning rules" that you approve. Then I implement. Fo Więcej

₹7000 INR w ciągu 5 dni
(26 Oceny)
6.5
archanaoswal

I can write a formula or a macro to extract unique values from one or more columns I have excellent command on MS Excel. I have completed complex projects in Excel before. For instance - Create a schedule for de Więcej

₹2500 INR w ciągu 1 dnia
(50 Oceny)
5.3
sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Więcej

₹1750 INR w ciągu 1 dnia
(77 Oceny)
5.2
mail2vimalarora

Hi, I have gone through your project details and can help you in getting unique data from huge set of duplicated data quickly and efficiently. Being experienced in working on several data filtration and such related t Więcej

₹2250 INR w ciągu 2 dni
(57 Oceny)
5.4
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Więcej

₹5555 INR w ciągu 3 dni
(51 Oceny)
4.7
sevillajk01

hi! let me help you with your project. I have read the details of your need and I am confident that I can deliver it. thanks

₹1600 INR w ciągu 2 dni
(6 Oceny)
2.4
infoMGTS

Hello, I have checked the attached CSV file and to do this work with 100% accuracy we have to sort the data and check for all similar entries and determine which group should be put into one unique record. As you Więcej

₹10000 INR w ciągu 5 dni
(38 Oceny)
2.4
antoinepal

Hello, I am an experienced Data Analyst with advanced skills in Excel. I can give you quality work. Please check my portfolio in order to see my work. Just give me the opportunity to show you what i can do. Than Więcej

₹6666 INR w ciągu 3 dni
(6 Oceny)
2.6
rakesh691

Hello, We are team of two person working in the field of Data analysis, Machine Learning ,data cleaning and data imputation Relevant Skills and Experience Excel R language Regular expression We will use Excel w Więcej

₹8888 INR w ciągu 1 dnia
(1 Ocena)
2.3
prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write VBA programme for you that will pull specific data on the given conditions. Please come on chat for more details. Await Więcej

₹1500 INR w ciągu 2 dni
(30 Oceny)
1.6
phaniramp875

Hi, I was working as a business development executive in email marketing domain. I was very good in data mining because we have to generate our own data. If you could provide me the details I can send you the sample as Więcej

₹11111 INR w ciągu 20 dni
(1 Ocena)
1.7
mankit121

Hey In have read your project description. And I think I can do this work with simple Python code. In have done similar work using python. PS- Price is negotiable thanks.

₹1500 INR w ciągu 2 dni
(5 Oceny)
0.6
Miguelmasr2195

Hi, I have an computer engineering degree and great skills with excel, I can do this job for job for you in just one day if want to work with me just message me.

₹1750 INR w ciągu 1 dnia
(1 Ocena)
0.3
₹4444 INR w ciągu 7 dni
(3 Oceny)
0.4
jayalakshmivel02

I am interested on this job i Will do this within day

₹7777 INR w ciągu 3 dni
(0 Oceny)
0.0
saurabhmedha347

Give me a chance to complete this work

₹1650 INR w ciągu 3 dni
(0 Oceny)
0.0
₹2250 INR w ciągu 3 dni
(0 Oceny)
0.0
₹8888 INR w ciągu 3 dni
(0 Oceny)
0.0
AlRom

I am currently working in the software automation industry, and I deal with projects like these on a daily basis. I have the technical experience and the tools necessary to finish this job, without errors, in the least Więcej

₹3333 INR w ciągu 1 dnia
(0 Oceny)
0.0