Find Jobs
Hire Freelancers

Find the most common words and list them in order from 1,000,000 rows in excel - Small job

$10-30 AUD

Completed
Posted about 3 years ago

$10-30 AUD

Paid on delivery
We have an excel file and need the right formula that will allow us to list in order the highest to lowest amount of time a word is used in 1,000,000 rows. Each cell is different with words, however there are many of the same word in multiple cells. We wish to analyse all of them and have a list of the most commonly used words as a list form biggest to smallest. - Small job for someone that knows how to do the formula
Project ID: 29272837

About the project

52 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I went thru the details and the file Contact me and I will do it RIGHT NOW I look forward to hearing from you Thanks Regards Thushara
$30 AUD in 1 day
5.0 (40 reviews)
5.2
5.2
52 freelancers are bidding on average $23 AUD for this job
User Avatar
Hi sir, Ok understood, I am interested in working on this project. I can create a sample work for you. Please contact me to discuss further. Thank you.
$30 AUD in 1 day
4.8 (306 reviews)
7.4
7.4
User Avatar
Hi there, I have read the project description carefully & can deliver the work in an hour. Hope to chat with you soon! Thanks & Regards, Jyoti Joshi
$25 AUD in 1 day
4.9 (172 reviews)
6.9
6.9
User Avatar
Hi, I have a macro that extracts and counts unique words from search term in column A. Here is an output for your sample with 54k rows (top ten): for 6675 women 2383 men 1142 and 874 the 830 with 769 case 656 kids 655 baby 624 dog 579 Let’s discuss if you’re interested. Best regards, Duong
$100 AUD in 1 day
4.9 (66 reviews)
6.6
6.6
User Avatar
Hi, As I understand you need to find out usage of Word across multiple cells and then rank them in order of occurrence. Is formula must, would macro be ok as well. Looking forward to your response. Thanks
$30 AUD in 1 day
4.9 (116 reviews)
6.4
6.4
User Avatar
Hello, I can find most common word (basically I will be able to tell which word comes how many times in the excel sheet) for you and I can start on the project right away. You can check my profile for reviews. I can assure good quality work and timely delivery. Looking forward to hearing from you to discuss further details.
$30 AUD in 1 day
5.0 (44 reviews)
5.5
5.5
User Avatar
Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can write a MACRO to list common words with its count. Looking forward to hearing from you. Thanks
$50 AUD in 1 day
5.0 (44 reviews)
5.3
5.3
User Avatar
Hi there, I have read and understood the description. I'd be grateful and honored to work on this project. Feel free to message me so we can discuss the project furthermore. Please check via below link what are the clients said about my previous works and Portfolio - https://www.freelancer.com/u/jnpkfb Best regards, K P Janaka PS: Please have a look at the reviews given to me on this platform.
$30 AUD in 2 days
4.8 (54 reviews)
4.7
4.7
User Avatar
Hi there, I am an expert in excel formulas and I will list and sort the words in excel ASAP. I am ready to start now and deliver work in few hours. Thanks.
$20 AUD in 1 day
4.8 (47 reviews)
4.8
4.8
User Avatar
Greetings, I think you are looking for someone for your project who expert in Excel working. i finish work in similar project about 500,000 rows. I think there is no detailed discussion of the work here. So, we can discuss more work? First of all, I'll provide you a Demo file of work. If you like the job samples, you can work with me. I am waiting for your Kind Response. Thank you
$10 AUD in 1 day
5.0 (23 reviews)
4.2
4.2
User Avatar
Hi, I have split the "SEARCH TERM" column in the attached EXCEL file by word and sorted it in descending order according to the number of occurrences. The first 10 words appear as follows. words counts for 6634 women 2262 men 1111 and 823 the 818 with 744 kids 644 case 638 baby 621 The query result is obtained through the query function of EXCEL, and the query process exists in the document, looking forward to working with you.
$10 AUD in 1 day
5.0 (13 reviews)
3.1
3.1
User Avatar
Dear client. Here is data processing expert. I have just read your requirement at carefully. I'm an expert of data processing by using many Excel macros such as DAX, pivotTable managing and excel VBA. I have developed many data entry projects similar with your project and during that time I increased my skills to high level. If you give me a chance, I will do my best for your project. project deadline : complete within 24hrs or max 36hrs I will not disappoint you, please give me an opportunity to work with you. I hope many discussion. Thanks.
$30 AUD in 1 day
5.0 (7 reviews)
3.1
3.1
User Avatar
Hello over there (down under!) By this time probably it's solved, but send me a message because I have a solution that will make the formula speed up at least 100x (and probably 1000x). Let me know if interested, it won't be any expensive, and the value out of it will be BIG (in terms of the time saved by the speed-up solution). Best regards, Jose Luis
$30 AUD in 7 days
5.0 (11 reviews)
3.1
3.1
User Avatar
I can do this project right now with 100% accuracy. I understood your project description. I am an expert in Data Entry, Excel, Word, Web Search, and interested in your project. I work efficiently and will finish on time, and will provide high-quality work. I am waiting for your quick positive reply, and If you need any samples, please let me know. Thanks
$20 AUD in 1 day
4.9 (9 reviews)
3.0
3.0
User Avatar
Hi I can get this done in a few hours. Please message to get the output file. Thanks and Regards Mohit
$15 AUD in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi there, My name is Shazia. I can complete your work as soon as possible if you're interested in my bid please contact me Thanks and Regards
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey Hope you are doing god I am quiet good with excel good and would love to take up your job as i think i can do the same with the help of pivots and if formulae and other if require. Do give a chance
$30 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, My name is Haris Nokhaiz. I can complete your work as soon as possible if you're interested in my bid please contact me Thanks and Regards
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
im very good at this. so u can trust me. and will be a pleasure to do work with u. honestly I do mt work with very good spirit and complete as soon as possible. hope we will work together.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I work well in Excel 5 years experience. you will understand the work in time. I do any job very well And with time. I hope you will be very satisfied with my work. If you work from me for the first time, you will look for me a second time. Thank you.
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I’m an MBA student and work as Manager of Sales & Customer Service department, I'm very efficient & on time, and I believe due to my good knowledge and experience in using different Microsoft Office programs as well as Google Sheets, I will be suitable for this task. and of course you are more than welcome to chat and request any kind of changes upon receiving the excel sheet. Really appreciate the opportunity! P.S I can also prepare you a report with the filtered data via Data Studio for more friendly view
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
59
Payment method verified
Member since Jul 18, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.