I need a spreadsheet wizard!
- or -
Post a project like this$$
- Posted:
- Proposals: 29
- Remote
- #1802233
- Expired
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Greater Noida
Spreadsheets and Databases Development, Data Mining, Development (VBA, Visual Basic, SQL), Finance, Financial Markets
Denny
176840314140071426987144947314670171536547166725617291341934141191026319095731935914
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
* WE NEED A SPREADSHEET WIZARD*
Here is the situation...
We have a website that we are running a raffle from. Customers can buy tickets from the site and they have the option to buy more than one ticket to increase their chances of winning.
When we export all the names of the ticket buyers into a spreadsheet (currently numbers, but could be google sheets or excel) each name comes up listed once.
We need someone who can see the number of ticket purchases an individual has made and then duplicate there name that amount of times in the document.
This way when we randomly pick a number, they will have a higher chance of winning.
For example. If you bought 5 tickets your name would need to be in the spreadsheet 5 times. If you only bought one then your name only appears once on the spreadsheet.
We are expecting a very large volume of names to be on the spreadsheet. So we are hoping that there is someone who knows how to automate this process as doing it manually isn't going to be possible with the number of entries we will have.
Very happy to answer any questions if I haven't been clear on the brief.
Hope to hear from you.
Best
Alex
Here is the situation...
We have a website that we are running a raffle from. Customers can buy tickets from the site and they have the option to buy more than one ticket to increase their chances of winning.
When we export all the names of the ticket buyers into a spreadsheet (currently numbers, but could be google sheets or excel) each name comes up listed once.
We need someone who can see the number of ticket purchases an individual has made and then duplicate there name that amount of times in the document.
This way when we randomly pick a number, they will have a higher chance of winning.
For example. If you bought 5 tickets your name would need to be in the spreadsheet 5 times. If you only bought one then your name only appears once on the spreadsheet.
We are expecting a very large volume of names to be on the spreadsheet. So we are hoping that there is someone who knows how to automate this process as doing it manually isn't going to be possible with the number of entries we will have.
Very happy to answer any questions if I haven't been clear on the brief.
Hope to hear from you.
Best
Alex
Alex W.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
14 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Alex
What is your site url? -
Hi Alex,
Can you share a sample of data exported to excel?
Thanks -
When you export the purchasers names to excel, will you also be exporting the number of tickets e.g Fred Smith 4 ?
-
Hi Alex,
According to you how many tickets are sold in a day, by getting this answer I can provide you better solution.
Thanks.
546078545872545865545815
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies