Suoritettu

Excel Formula Help

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

*You should see an attached file to this project called example.xlsx

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic

Näytä lisää: microsoft excel formulas list with examples, advanced excel formulas, excel formulas cheat sheet, excel formulas if, basic excel formulas pdf, advanced excel formulas pdf, excel formula download, excel formulas pdf, want to write a novel but don t know what to do, price list excel formula, i want to write a book but i don t know where to start, i have an event and want an artist but don t know how much they charge, i don t know accounts but i want accounts, don t know how to write a book but want to who could i talk to to help write a book, there is a design that nomarlly appear in a flyer though i don t know what it is called but i really want to learn it, need help with excel formula, i want to write a book but don t know where to start, excel formula help: need one-to-many vlookup type of formula, excel formula help, excel formula help need onetomany vlookup type of formula

Tietoa työnantajasta:
( 126 arvostelua ) brooklyn, United States

Projektin tunnus: #17380132

Myönnetty käyttäjälle:

$10 USD 3 päivässä
(0 Arvostelua)
0.0

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$10 USD 1 päivässä
(374 arvostelua)
7.3
khushh07

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 1 päivässä
(277 arvostelua)
7.1
hdlong66

Hello, I will send you a completed Excel 2007 file for your review if you're interested. Best regards, Hoang

$30 USD 0 päivässä
(140 arvostelua)
6.9
shafaqat11

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 1 päivässä
(104 arvostelua)
5.8
$15 USD 10 päivässä
(18 arvostelua)
4.9
$10 USD 10 päivässä
(11 arvostelua)
3.3
cranius

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 avail Lisää

$29 USD 1 päivässä
(9 arvostelua)
3.5
$10 USD 1 päivässä
(9 arvostelua)
3.2
sdroberts

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 0 päivässä
(2 arvostelua)
2.4
albert0124

Hello! I saw the [login to view URL] file and it has a header on every single day. I have a solution. In the "Records" worksheet, I removed the extra headers between the data; only the top header remained. Then, I use P Lisää

$10 USD 1 päivässä
(2 arvostelua)
2.1
ShubhamTT

Dear Sir, I have gone through project description and interested in taking it up. Posted bid amount is indicative and a more accurate I can give once more details are shared. Looking forward to hearing from you. Thanks

$10 USD 10 päivässä
(0 arvostelua)
0.0