Analyse spreadsheet of enquiries - identify duplicates, prepare analysis year on year
- or -
Post a project like this3231
£7/hr(approx. $9/hr)
- Posted:
- Proposals: 10
- Remote
- #792464
- Awarded
Business Analyst, VBA Programmer, Microsoft Excel Expert, Proofreader, Qlik Sense Data Architect, Qlik Sense Visualisations Expert
Glasgow
Experienced Professional All-rounder. Compliance, Process management and improvement, Program and Project mgt
London
432743443720471853617683637658893483899869937522940261944220
Description
Experience Level: Entry
Analysis tool: Excel
Description of analysis: I have a spreadsheet of enquiries between 1 April 2012 and 29 May 2015. Our financial years run 1 April to 31 March.
When someone makes an individual enquiry, it is sent to multiple branches. As such, the spreadsheet has about 4000 rows, but many fewer individual enquiries.
I need to have spreadsheet reviewed and the individual enquiries split out by financial year and then a summary showing:
1. the financial year
2. the number of individual enquiries
3. the total number of enquiries
I attach an example of 100 rows . The actual spreadsheet has about 4000 rows. I've highlighted a couple of rows which show the individual enquiries being sent to multiple branches.
Extra notes:
Description of analysis: I have a spreadsheet of enquiries between 1 April 2012 and 29 May 2015. Our financial years run 1 April to 31 March.
When someone makes an individual enquiry, it is sent to multiple branches. As such, the spreadsheet has about 4000 rows, but many fewer individual enquiries.
I need to have spreadsheet reviewed and the individual enquiries split out by financial year and then a summary showing:
1. the financial year
2. the number of individual enquiries
3. the total number of enquiries
I attach an example of 100 rows . The actual spreadsheet has about 4000 rows. I've highlighted a couple of rows which show the individual enquiries being sent to multiple branches.
Extra notes:
Lettingweb L.
100% (65)Projects Completed
43
Freelancers worked with
27
Projects awarded
58%
Last project
23 Jun 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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