User Defined Excel Function for text categorisation
€30-250 EUR
Paid on delivery
We want to build a user defined function for text categorisation that does the following:
- Looks into a text string,
- Finds the presence of words in the text tring
- Words to be found are among a Data base of words,
- Each word of the list is associated to other words
- The function returns 1) The word(s) found in the texted string 2) the associated word(s)
Example:
Text string: "Alice runs in the woods and falls into a hole"
Word Data Base:
(...)
Alice: story, rabit, disney...
Wood: nature, trees...
(...)
Function(TextString, Word1) = Alice
Function(TextString, Word2) = Wood
Function(TextString, Word1, Associated1)=story
Function(TextString, Word1, Associated2)=rabit
Function(TextString, Word2, Associated1)=nature
Function(TextString, Word x, Associated y) = z
!!Specials:
- The list of words and associated words have to be inputable in colums (i.e the dictionnary is in a excel sheet, not hard coded in the function)
- The function should be more effective and less calculation consuming than the use of sheet unsing multiple search() functions on each word
Project ID: #8976739
About the project
Awarded to:
Hello Sir, Thanks for the prospect project and I would like to work on the same. I believe have placed a justified bid on the same. As you know well, you can pay me only when your job is 100% done. Thanks, Jay
45 freelancers are bidding on average €104 for this job
Hi, my name is Sevinc. I read your excel function project descriptions carefully before bidding. I checked your requirements, and I got what you need. I am ready to go ahead as soon as we can clarify further project More
Hi! Do you want the function in excel ? If yes, I can start working right now to finish it ASAP. Regards
Hi, I ll code these function in an Excel VBA macro. I need just a sample file. And yes the words will be in the workbook not hard coded. So the macro will work for any number of words. I can start and finish in less th More
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard More
I can build the custom function for your VBA need. Just drop me a message and we start asap.. Thanks...........
Hi: Please note that over 90% of my completed projects are related to Excel. Moreover, I have 100% completion rate and 5-star feedback on projects.
Hi! I am a new freelancer specializing in Excel, I want to earn a good reputation with you!
Hello I can get you this task implemented using Excel VBA in the next 12 to 24 hours. Do let me know if you are interested. Thanks
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details More
I may code the function in order to return an array where you can choose the main word and the secondary ones just using something like =YourFunction (TextString, MainWords, Secondary) (1,2) that will return the main w More
Hi I am interested in this project. I am an experienced VBA developer. I can do this job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks Regards Jawad