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

Terminado
Publicado hace más de 3 años

$10-30 AUD

Pagado a la entrega
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 del proyecto: 29272837

Información sobre el proyecto

52 propuestas
Proyecto remoto
Activo hace 3 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (40 comentarios)
5,2
5,2
52 freelancers están ofertando un promedio de $23 AUD por este trabajo
Avatar del usuario
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 en 1 día
4,8 (306 comentarios)
7,4
7,4
Avatar del usuario
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 en 1 día
4,9 (172 comentarios)
6,9
6,9
Avatar del usuario
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 en 1 día
4,9 (66 comentarios)
6,6
6,6
Avatar del usuario
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 en 1 día
4,9 (116 comentarios)
6,4
6,4
Avatar del usuario
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 en 1 día
5,0 (44 comentarios)
5,5
5,5
Avatar del usuario
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 en 1 día
5,0 (44 comentarios)
5,3
5,3
Avatar del usuario
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 en 2 días
4,8 (54 comentarios)
4,7
4,7
Avatar del usuario
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 en 1 día
4,8 (47 comentarios)
4,8
4,8
Avatar del usuario
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 en 1 día
5,0 (23 comentarios)
4,2
4,2
Avatar del usuario
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 en 1 día
5,0 (13 comentarios)
3,1
3,1
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
3,1
3,1
Avatar del usuario
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 en 7 días
5,0 (11 comentarios)
3,1
3,1
Avatar del usuario
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 en 1 día
4,9 (9 comentarios)
3,0
3,0
Avatar del usuario
Hi I can get this done in a few hours. Please message to get the output file. Thanks and Regards Mohit
$15 AUD en 1 día
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
5,0
59
Forma de pago verificada
Miembro desde jul 18, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.