Find Jobs
Hire Freelancers

Advice on either pivot table or macro

$10-30 AUD

Closed
Posted over 8 years ago

$10-30 AUD

Paid on delivery
I want to write a macro (or pivot table filter) that will identify in a 10,000 entry datasheet of enrolment events which units have only teachers in them, but no students. So there will be one column which has a unit code and will have between 2 and 50 duplicate rows around it denoting enrolment events of both teachers and students. The designator of whether a unit is a real teaching unit is whether it has students enrolled; however some units appear in the datasheet but only have teachers enrolled, not students, and are therefore not real teaching units (they might be training, etc). I want to put this data into a pivot table that shows me distinct counts of units, students and teachers, but which does not count units or teachers in which no students are enrolled. The student/teacher data is a row entry in the next column to the unit code. To reiterate, I want my pivot table to report distinct counts of units, students and teachers, but only for those units that have students in them - I do not want to count units that only have teachers in them. Any suggestions?
Project ID: 8663790

About the project

17 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $35 AUD for this job
User Avatar
A proposal has not yet been provided
$30 AUD in 0 day
5.0 (337 reviews)
7.7
7.7
User Avatar
can make quick suggestion I am mostly online. Just drop me a message so that we can discuss further about pricing and job details.
$29 AUD in 1 day
5.0 (78 reviews)
6.7
6.7
User Avatar
A proposal has not yet been provided
$100 AUD in 1 day
4.9 (101 reviews)
6.9
6.9
User Avatar
Hi, We are experts in Excel. This can be done putting a condition or filter within the pivot table itself to separate out the units which only have students in them. We need to however once check the data. Kindly message us for further discussions. Regards, Pal
$23 AUD in 1 day
4.8 (18 reviews)
4.5
4.5
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$50 AUD in 2 days
4.8 (22 reviews)
4.7
4.7
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$30 AUD in 1 day
4.6 (22 reviews)
4.7
4.7
User Avatar
I have the expertise in writing macros and pivot tables in Excel and can help you on this task, starting immediately.
$25 AUD in 1 day
4.9 (28 reviews)
4.2
4.2
User Avatar
I am an expert in delivering custom software and also .NET looking forward to discuss further about the project
$84 AUD in 4 days
4.8 (9 reviews)
4.1
4.1
User Avatar
HI, pls see profile and award me. Thx______________________________________________________________________________________________
$40 AUD in 1 day
5.0 (8 reviews)
4.0
4.0
User Avatar
Hi, I'm on this site just since 1 month, but I'm very skilled on excel. I'd like to give a look at your file, in order to send it back with the solution and its explanation. Can you send it to me via frelancers chat? I hope to be contacted, regards Andrea
$15 AUD in 1 day
4.8 (8 reviews)
2.2
2.2
User Avatar
Hello I can help you to get it done quickly. I have 10+ years experience in Microsoft Technologies development Like MS SQL, Visual Basic, MS Access and Excel. Thanks Guru Venkat
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I understand that you need to extract only teaching units where an enrolment counts when a teacher and a student together are enrolled. I can create a macro to loop through each row to check this condition and do a distinct count on this while copying the extracted data to a certain place on the excel sheet. Regards :)
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in Ms. Excel. I can work well, professional, and quickly. I often make my project with Ms. Excel and use pivot table filter. If you choose me to work your project, you will satisfy with my work.
$15 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Thanks for reading my proposal. Being NZ-Based means that I can communicate with you during standard business hours. My familiarity with Pivot Tables means that I could do this within an hour of receipt of data (during business hours, other times may take a while longer). Hiring me to do this job will mean the sheet is completed quickly and accurately, allowing you to get on with using the output data for your required usage almost immediately. Once again, thank you for your consideration.
$20 AUD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Đề xuất vẫn chưa được gửi
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Oct 12, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.