Excel UDF Function - Get the last available value in a list (10 min work for right person)

€8-30 EUR

Fullført

Lagt ut

nesten 7 år siden

€8-30 EUR

Betalt ved levering

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.

Excel

Visual Basic

Prosjekt-ID: 14405646

Om prosjektet

10 forslag

Eksternt prosjekt

Aktiv 7 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@Ahmed818

let's begin , i can finish in 10 minuites Relevant Skills and Experience expert in excel vba programming Proposed Milestones €20 EUR - macro

€11 EUR om 0 dag

4,8

(47 omtaler)

4,3

10 frilansere byr i gjennomsnitt €19 EUR for denne jobben

@schoudhary1553

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

€20 EUR om 0 dag

4,9

(319 omtaler)

7,9

@khushh07

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

€22 EUR om 0 dag

4,8

(250 omtaler)

7,0

@shafaqat11

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

€16 EUR om 0 dag

4,9

(94 omtaler)

6,1

@ketas

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

€19 EUR om 0 dag