We’re looking for an expert VBA coder to write an quick and easy to use macro for Excel 2016 for a simple text processing exercise.
Goal: we’re looking for social media users to vote for one of several performances in a streamed video by using the comments functionality. Each performance can only be scored during a specific period of time. We will encourage them to post a comment with a flame emoji to cast their vote at the right time. But we will only allow them to vote once, so will need to only register their first comment that contains a flame emoji and ignore any further posts from that.
Please see the attached sample chat export text file Also a proposed UI for entering time segments and receiving results (we’re open to anything that works)
I’d expect the process to work something like this...
* Filter list for only comments that include flame emoji
* De-dupe rows based on Username, retaining only the first comment for each user
* Count the rows within the given time range and present back
Would be good to be able to see workings eg. sheets showing interim stages
Hello. I have more than enough experience to prepare this project for you. I've even prepared most of it while just playing with the txt file in VBA. Message me for a quick and precise solution. Best regards.
Here is a sample image. This list was created by my script, which i've prepared just now. If shows only fire including lines, and filters out repeating messages from same users.
https:// [login to view URL] /zFHXTXk
$30 USD en 1 día
5,0 (94 comentarios)
6,0
6,0
8 freelancers están ofertando un promedio de $34 USD por este trabajo
Hi Sir,
I went through the files. I can complete this job within hour or two. Please ping back to get started right away.
Please check my past reviews. I have 10+ years of experience.
Thank You
Regards
Rishi
Hi, Greetings!
✅checked your project details:
Excel Macro to Process a Text File & Count Items
✅Attachments : Seen
✅Completed Time: 24 hours or your requirement deadline .
I have 5 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. I can start working immediately on this project if needed.I have gone through the job description and understand your requirements.I can complete this work with high quality.
✅Why choose me?
- 100% Job satisfaction with quality
- Low hourly rate and with in budget
-Timely updates and on time delivery
-Support for Life Time
-Unlimited revisions
✅My Portfolio Items: https://www.freelancer.com/u/kingqueen369
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Mehedi