Excel Macro to Process a Text File & Count Items

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

Habilidades: Excel Macros, Excel VBA, Excel, Visual Basic

Veja mais: excel macro read text file, excel macro chinese text, excel macro parse text file, excel macro format text, excel macro check text format, excel macro edit text file macro, excel macro clean text, excel macro convert text file excel, excel macro convert text number, excel macro find text word file, excel macro generate text file excel, excel macro insert text internet explorer, excel macro search text word doc lines, excel macro write text file, excel macro compare text, excel macro import text file into specific sheet, excel macro import text file delimited, excel macro delimited text file

Acerca do Empregador:
( 39 comentários ) London, United Kingdom

ID do Projeto: #28314761

Concedido a:


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 Mais

$30 USD em 1 dia
(70 Comentários)

10 freelancers estão ofertando em média $32 nesse trabalho

(315 Comentários)
(146 Comentários)
(187 Comentários)

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

$30 USD em 1 dia
(152 Comentários)

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 ki Mais

$20 USD em 1 dia
(17 Comentários)

Hi . This is Yesu ,I am Working as VBA/Python developer for 5 years I work on automations of [login to view URL] [login to view URL] [login to view URL] [login to view URL] Point [login to view URL] [login to view URL](limited) We use Macros,VBScripts,API's,Selenium, for process I can Mais

$20 USD em 1 dia
(16 Comentários)

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with file processing using Excel macro. Everyone call me a "Prince of Excel". I promise I will finish th Mais

$30 USD em 1 dia
(1 Comentário)

Hi, appreciate if you took the time to review my proposal. New to this platform but I am very familiar with MS Excel and have experienced completing few projects. I am used with Excel VBA, Macros, Userform and other f Mais

$20 USD em 1 dia
(2 Comentários)

Hello, I am a professional data entry operator. I can do your work in 1 day. contact me for more details. Yhank you.

$15 USD em 1 dia
(0 Comentários)