Excel function
- or -
Post a project like this2712
$$
- Posted:
- Proposals: 10
- Remote
- #1343827
- Awarded
Excel Dashboard, Reporting Expert | VBA, Macros |Business Intelligence and Data Analytics | Power BI | Financial Analysis | Google Spreadsheet Design and Scripting | Python Expert | MT4 | MT4 Manager
Pune
Business tools for today's environment using Excel, Access & VBA scripts...
Stoke-on-Trent
Web Designer (Front End Developer) | Content Management | Data Entry | Virtual Assistant
Mandaluyong City
Web research|Lead Generation| email database | Linkedin Research | Data Research | Image annotation
Mumbai
1601804216709683681228050139184213940151412412142033914230061423161
Description
Experience Level: Intermediate
Description of excel work: Create a sort function for a payments ledger
Extra notes: Accounts sheet only. See the raw data in rows 18 - 115. Currently i manually sort it into groups with the finished result looking like rows 118 - 133.
Once I press the function button the raw data will be deleted and i will be left with the sorted only.
Sorting will carry out the following;
1. Sort Column A groups first
2. Then sort into Column F
3. Provide one total each for the titles in Column F
4. Provide a total at the bottom of the newly sorted data
5. Give a total for each group in Column A
And one more thing from the previous job please; for the email text could a final line be added in brackets;
(This is a system generated email)
Extra notes: Accounts sheet only. See the raw data in rows 18 - 115. Currently i manually sort it into groups with the finished result looking like rows 118 - 133.
Once I press the function button the raw data will be deleted and i will be left with the sorted only.
Sorting will carry out the following;
1. Sort Column A groups first
2. Then sort into Column F
3. Provide one total each for the titles in Column F
4. Provide a total at the bottom of the newly sorted data
5. Give a total for each group in Column A
And one more thing from the previous job please; for the email text could a final line be added in brackets;
(This is a system generated email)
George K.
99% (34)Projects Completed
37
Freelancers worked with
30
Projects awarded
57%
Last project
31 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello George,
would you send me the Excel file.
Thanks
Ivan -
Hello,
Could you please attach an excel file with dummy data to your job description? -
HI George!
I can't find your attachment, coudl you please re-upload it?
Kind regards! -
Hi
Share sample file
Regards -
I am wiling to do this job. Can you please tell me what is your work deadline and just one sample for this work?
214169212098212082212068211993
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies