I have 54,024 lines in total on 10 spreedsheets that I need worked on
with the following requirements:
I have attached a sheet with 2 tabs in it too demonstrate what I am looking to achieve.
1. In tab "ripon" you will see that column B is empty.
I require the race number to be inputted as seen in sheet "plumpton".
You can determine this by looking at column A (time) and column E (date).
Every time that the time increases, it represents a new race eg.1,2,3,4,5,,6,7,8,or 9.
Every time that the time decreases it represents a new day hence starting back at race 1.
Make all of column B "number" without any decimal places.
Centre column B.
2. In column G, I want the shortest price horse highlighted in grey and a corresponding "1" put
into column H. This represents the favourite.
When there are two horses in the same race with the same lowest price, please refer to column D "card number"
and choose the horse with the lowest number in column D as the favourite for that race eg. race 1 in Plumpton.
Make all of column H "number" without any decimal places.
Centre column H.
3. In column I, a formula is required. If H = 1 and F= 1 than display G.
The freelancer must use excel 2007 and must be able to start immediately.
Please see attached example.
After commencing the project, the freelancer must send through a completed example after 30 minutes of
work for analysis. This is to ensure that the task is being done correctly.
Funds will be put into escrow at the beginning of the project and released once the finished product
is delivered.
If the job is done well, I have more of the same work available.
Hello
I have lot of experience in Excel and have done lot of work on Macros and VB scripts. I can do this for you quickly and accurately. Please see my private message for more details.
Regards
Faisal
$200 USD in 2 days
5.0 (4 reviews)
3.4
3.4
22 freelancers are bidding on average $54 USD for this job
***************I HAVE THOROUGHLY READ THE DESCRIPTION AND MINUTELY LOOKED AT THE ATTACHED SAMPLE. READY TO GIVE THE DEMONSTRATION RIGHT NOW. PLEASE CHECK PMB***************