Excel UDF Function - Get the last available value in a list (10 min work for right person)
Budget €8-30 EUR
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.
Assegnato a:
let's begin , i can finish in 10 minuites Relevant Skills and Experience expert in excel vba programming Proposed Milestones €20 EUR - macro
12 freelance hanno fatto un'offerta media di €20 per questo lavoro
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 ex Più
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 Più
Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Più
Hi, sir I have a detail look to your project, I have a great skill in excel. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via chat. Thanks. Relevant Skills and Ex Più
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
Hi, very nice to meet you. I am so confident and I am sure that I can do your project. I can show you nice past work, it will be my great pleasure if you contact me for further discussing , thanks. Stay tuned, I'm i Più