Google sheet function to identify abbreviated words
$10-30 USD
Finalizat
Data postării: peste 4 ani în urmă
$10-30 USD
Plata la predare
Note: this must work in google sheets. Don't offer to do in Excel.
We have a list of words that have the vowels missing. We need a function that will take each cell in a selected column and add a number to the next column. (if column A is selected, numbers should be added to column B, etc). The number should equal the number of contiguous consanants at the start of a word. The first letter should be ignored and included as 1 in the count. If no vowels after the first letter, value should be set to 0.
Reminder: vowels = A,E,I,O,U, sometimes Y
Examples:
Prviding - 3 (three letters before i)
Advntis - 5 (five letters before i)
Andrwe - 5 (five letters before e)
Armstng - 0 (no vowels after the first letter)
Below is a link to a test sheet with words. Number to be added to column D. We are not sure if we want to include "Y" as a vowel. Make an easy way to change to add/remove Y as a vowel. To show us that you read this post and did not auto-bid-spam, put your favorite color as the **first word** in your bid.
File link:
https://docs.google.com/spreadsheets/d/1Mi-f3SNCNDRKFkCQaAaxbgC4T9zaxDkd0TD9AotDdbw/edit#gid=595045734
Good luck
black. that's my fav color!!!
hi there!
it's a very interesting project, as i keep all my records (including complex search/index/analytics/graphs) in my google sheets already. even, i'm using real-time currency conversion in google sheets...it is fascinating, indeed!
so, yes! i believe i can do this work in just a few hours....and has kept another day if any fix comes up.
if you're interested...plz let me know!
you can trust me on this!
thanks.
PS:
1. i've seen your google sheet file too...the function needs to be put in column D...vowels flag, right?
2. we can add 'Y' to be flagged as vowel or not...it's so simple...if i make a cell as input, where you'd mark Y as 0/1 or T/F...is that ok?
$30 USD în 2 zile
3,5 (4 recenzii)
2,4
2,4
6 freelanceri plasează o ofertă medie de $22 USD pentru proiect
Hi,
I am ready to start right away.
I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly.
I understood your all requirements. I have done many projects like this.
Can you send me a message? Then we can discuss the details.
Regards,
Noor
My friend... My prices are the lowest, my work is always original and I will give it before the deadline.
I am producing quality content for my clients including; ARTICLE WRITING, ESSAY WRITING, RESEARCH PAPERS, THESIS & DISSERTATIONS.
"Kindly try me Once, and get impressed forever"Click to the link and lets chat
https://www.freelancer.com/u/IdealExpert
Our company specializes in providing Data Entry/Data Processing work.
We are Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, I am the Right person for you. available 24-7. a trusted Freelancer
We have a team of efficient and professional experts in each of the fields of Data Entry and thus, each of our team members are dedicated to address and solve client’s individual needs. We always keep in mind that the services that we provide get proper and effective attention that it deserves.