Excel UDF Function - Get the last available value in a list (10 min work for right person)
€8-30 EUR
Finalizat
Data postării: aproape 7 ani în urmă
€8-30 EUR
Plata la predare
Very small project, 10 minutes work for right person:
Create a user defined function:
=LastAvailable(A5;0,n)
meaning:
If A5=0 then retrive A4 provided A4<>0,
else retrieve A3 provided A3<>0
else retrieve A2 provided A2 <>0
up to the Nth previous cell
0 should be a variable (meaning could be replaced by blank or anythin elese, in the above example:
=LastAvailable(A5;"",n)
meaning:
If A5=0 then retrive A4 provided A4<>"",
else retrieve A3 provided A3<>""
else retrieve A2 provided A2 <>""
etc.
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
Here is the reason. Why you should pick me?
a) I am a very expert and have the same kind of experience of 5 years.
b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers
c) And most important part is my policy:
"I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me”
Please sir, leave a reply ASAP, as I am waiting for your kind reply
Hi,
I understand the project requirements and willing to start as soon as possible.
Looking forward to work with you.
Thanks & Regards
Khushi
India
Relevant Skills and Experience
Excel, Visual Basic
Proposed Milestones
€22 EUR - milestone
Hello Sir,
Thank you for posting the project.
I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Thank you, and have a great day!
Kinds Regards,
Shafaqat Ali
Dear,
I could help you to make this request done in 20 minutes maximum.
Regards,
Relevant Skills and Experience
VBA/ MS Excel
Proposed Milestones
€20 EUR - Finish