Find Jobs
Hire Freelancers

Excel Formula Help

$10 USD

Fullført
Lagt ut over 5 år siden

$10 USD

Betalt ved levering
I am looking to take the example table and use the Records table to populate the Results tab with a kind of reports table based on date and getting distinct Name's automatically from the records tab The "Example Results I Want" tab shows what should be the end results you program into the Results tab This must work in Excel 2007 and Deadline is Thursday the 19th The Date column is used to get the records only for a date period I want The Name column list here is automatically generated from finding the distinct Names in the Name column The Actions and Amount row are tallied for that specific Name The Average is a simple average on the tally of Amount/Actions The total row on the bottom in grey is the totals of all Names and Average The Example results above are if for example I wanted only the results from the month of March The Date column in records is in european format, I would prefer it to be on the results page in USA format I don't know how to work with macros so I would prefer this done in formulas if possible. I was told using Sumif but could not figure it out myself
Prosjekt-ID: 17380132

Om prosjektet

10 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

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:
Brukeravatar
$10 USD om 3 dager
5,0 (5 omtaler)
3,4
3,4
10 freelancers are bidding on average $18 USD for this job
Brukeravatar
Hello.... Greetings to you !! I am an excel expert and interested to work with your project. I assure for high quality job. Please let me know when we can start.. Thanks
$15 USD om 1 dag
4,8 (336 omtaler)
7,3
7,3
Brukeravatar
Hello, I will send you a completed Excel 2007 file for your review if you're interested. Best regards, Hoang
$30 USD om 0 dag
5,0 (163 omtaler)
7,0
7,0
Brukeravatar
Hello Sir, Thank you for posting the project. My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently. Thanks so much! Shafaqat Ali
$25 USD om 1 dag
4,9 (107 omtaler)
6,2
6,2
Brukeravatar
I've done it. I can send straight away following payment. Unfortunately I cant send a screenshot to prove it's complete however it's fully done in formulae, so no macro required. Kind regards Steve
$30 USD om 0 dag
5,0 (8 omtaler)
4,0
4,0
Brukeravatar
Hi there, I read your description inside the file but I am afraid this cannot be accomplished with formulas only. I you allow me I can deliver a macro that will do the job and deliver as open code for you. I am available to do it immediately and deliver on the same day. At your disposal to discuss on chat. Please, do not hesitate to contact me even if offline, as I check the mobile messenger very often. Thanks for the attention.
$29 USD om 1 dag
5,0 (11 omtaler)
3,8
3,8

Om klienten

UNITED STATESs flagg
brooklyn, United States
5,0
127
Betalingsmetode bekreftet
Medlem siden nov. 3, 2003

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.