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

完了済み
投稿日: 3年以上前

$10-30 AUD

完了時にお支払い
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
プロジェクト ID: 29272837

プロジェクトについて

52個の提案
リモートプロジェクト
アクティブ 3年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 1日以内
5.0 (40 レビュー)
5.2
5.2
この仕事に52人のフリーランサーが、平均$23 AUDで入札しています
ユーザーアバター
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 1日以内
4.8 (306 レビュー)
7.4
7.4
ユーザーアバター
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 1日以内
4.9 (172 レビュー)
6.9
6.9
ユーザーアバター
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 1日以内
4.9 (66 レビュー)
6.6
6.6
ユーザーアバター
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 1日以内
4.9 (116 レビュー)
6.4
6.4
ユーザーアバター
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 1日以内
5.0 (44 レビュー)
5.5
5.5
ユーザーアバター
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 1日以内
5.0 (44 レビュー)
5.3
5.3
ユーザーアバター
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 2日以内
4.8 (54 レビュー)
4.7
4.7
ユーザーアバター
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 1日以内
4.8 (47 レビュー)
4.8
4.8
ユーザーアバター
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 1日以内
5.0 (23 レビュー)
4.2
4.2
ユーザーアバター
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 1日以内
5.0 (13 レビュー)
3.1
3.1
ユーザーアバター
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 1日以内
5.0 (7 レビュー)
3.1
3.1
ユーザーアバター
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 7日以内
5.0 (11 レビュー)
3.1
3.1
ユーザーアバター
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 1日以内
4.9 (9 レビュー)
3.0
3.0
ユーザーアバター
Hi I can get this done in a few hours. Please message to get the output file. Thanks and Regards Mohit
$15 AUD 1日以内
5.0 (3 レビュー)
2.4
2.4
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

AUSTRALIAのフラグ
Melbourne, Australia
5.0
59
お支払い方法確認済み
メンバー登録日:7月 18, 2014

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。