진행중

Excel Macros needed to create dictionary from text and search for phrases

Overview:

I need an Excel macro that will parse data from separate Excel files and build a dictionary of unique words and phrases and a count of each word used.

Additionally, I need the separate ability to:

1) specify a particular phrase (e.g, 'your moma') to be searched for in the data, create a list of users who have used that phrase, as well as the total number of uses of the phrase; and

2) record the searched-for phrase, and record the number of times used in a month/year.

It is expected that a number of different Excel files will be processed sequentially.

See attached document for specific requirements.

Sample input Excel data file added. Column A = Author; Column E = Text, and F = Date. Search Phrase = 'in the'. Expect to find nine instances.

기술: 엑셀, 비쥬얼 베이직, 데이터 처리, Excel Macros

확대 보기: vba dictionary get item by key, vba loop through dictionary, excel vba dictionary, vba dictionary vs collection, vba dictionary multiple items per key, vba dictionary of dictionaries, vba dictionary keys, vba dictionary of arrays, create simple text graphic jpg, create query query search results php, excel macros comparing, excel macros create text files excel, sql full text search engine, excel macros programmer, excel macros unicode, converting lotus 123 macros excel macros, create image text, excel macros parameters, excel macros address correction, create full text based game php

고용주 소개:
( 2건의 리뷰 ) Albany, United States

프로젝트 ID: #25658347

수상자:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will search for specific phrases in other workbooks and 더 보기

$180 USD (5일 이내)
(263건의 리뷰)
7.6

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 32명, 평균 입찰가: $144

jaylancer43

Hello Sir, I can create VBA codes in Excel for you to parse the data as well as provide search automatically, we can discuss more. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have 더 보기

$250 USD (3일 이내)
(781 리뷰)
8.6
zekovicm

Hi there,I am a Excel macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within t 더 보기

$185 USD (2일 이내)
(144 리뷰)
7.4
elqueabandona

Hi, how are you?, my name is Cristian and i am Excel/VBA expert. I can write a macro that goes through a certain folder (selected by the user) and according to a series of parameters (phrases to search) generates the 더 보기

$220 USD (4일 이내)
(270 리뷰)
7.1
finecodervw

Hi, I have gone through both the attachments i.e. Sample data for [login to view URL] and RFP - Data Dictionary creator.txt. With my experience on Excel VBA, I can help to build the functionality for Build dictionary as well 더 보기

$175 USD (5일 이내)
(102 리뷰)
6.0
AnowarRatul

Dear Sir, I have read your project details and reviewed attachment very carefully. I can make the advance formula by maintaining 100% accuracy of your data absolutely as you want. Excel Dashboard Design, VBA Macro Codi 더 보기

$159 USD (4일 이내)
(108 리뷰)
5.3
merinsinha

Hi i am Excel VBA expert. Hi i can do your work perfectly. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best qualit 더 보기

$150 USD (3일 이내)
(28 리뷰)
4.0
VbaStudio

Hello. I'm a specialist in Excel and macros programming. I have read what you want to do and I'm able to do it. Regards.

$100 USD (7일 이내)
(5 리뷰)
3.4
superseoservice

Hi there, I would like to work on your project and want to be discussions. I have 4+ years of experience in the field. I can start working immediately on this project if needed. I have gone through the job description 더 보기

$200 USD (4일 이내)
(7 리뷰)
3.3
dheerajjshetty19

Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further 더 보기

$30 USD (1일 이내)
(17 리뷰)
3.3
witoon1980

Hello. I am Witoon, Excel VBA Expert. I am familiar with this kind of job. Open file, look up, data manipulation and automatic report maker. Please feel free to message me if you interest. Thank you very much.

$70 USD (2일 이내)
(8 리뷰)
3.0
murugesan24

Hi, I have over 25 years of experience in software development . I have gone through your requirement and I am comfortable in doing the same. I would like to go through the reviews which I got from my previous works in 더 보기

$250 USD (5일 이내)
(1 리뷰)
1.1
schands027

I am a self-dependent post-graduate student from BANARAS HINDU UNIVERSITY (INDIA). Seeking for a job to look after my educational expenses. I use a laptop for my studies that's make me suitable for your job as I have g 더 보기

$140 USD (7일 이내)
(0 리뷰)
0.0
tolgaozer0006

Dear Sir, My Current Responsibilities: *Identify process bottlenecks and opportunities for improving equipment cycle time and material throughput *Lead projects to enhance manufacturing capabilities through innovative 더 보기

$140 USD (7일 이내)
(0 리뷰)
0.0
Tapanjyoti2020

I am putting my best knowledge and efficiency in to every works. I have done my all jobs with an administrative professionalism and versatile office skills.I am confident that I would be a valuable asset to you.

$245 USD (7일 이내)
(0 리뷰)
0.0
khanmohammedalt7

Hello, I have great work experience of 5 years in excel with skill such pivot table,macros,conditional formating,H lookup and V lookup,VBA etc.I can complete your task as per requirement before the committed [login to view URL] 더 보기

$30 USD (5일 이내)
(0 리뷰)
0.0
Thakur00001

Plese give mi

$156 USD (4일 이내)
(0 리뷰)
0.0
vladajo2000

Dear sir. I'm professional in this field of Excel VBA, and have 7++ years old experience. As an expert, I guarantee that I can provide excellent solution in time. Payment will be done only based on your satisfaction an 더 보기

$100 USD (7일 이내)
(0 리뷰)
0.0
mangaihemu

I'm the kind of person execute difficult tasks with precision. I pay attention to all the details of a project. I make sure that every task is just right and that it is completed in a timely manner. Relevant Skills an 더 보기

$144 USD (3일 이내)
(0 리뷰)
0.0
gavvalrajeshwar7

I Have handled this type of projects so I request or add a proposal to give me this opportunity for doing this project

$140 USD (7일 이내)
(0 리뷰)
0.0
Gsharma11

Hii sir I am experience person I have six year experience as financial accounting & data management data analysis work I provide you best quality & services Thankyou

$156 USD (3일 이내)
(0 리뷰)
0.0