Forum Discussion
Need help with Excel
Hello All , I have a query -I have a list of people attending an office site .For ex-There are 100 people in that office site. I need to calculate how many % of people attending 3 Days a week?
Hi mathetes
Thanks for your response. It is for a one-time presentation only. Very Very Basic
Need a simple one, so I have created a sample data set for ex last November whole month -1. The employee names are present 2. The employee ID 3. The office attending date (it doesn't matter if they go within 15 seconds).
In addition, I added the week numbers, so week 1 Nov, week 2 Nov, etc.(MON -FRIDAY) First task was to see the weekly attendance - I created a pivot of people with their weekly attendance to the office .
After that an Additional requirement is to see how many % of people are coming 3 days a week. Accordingly, the file has attendance data for 100 people, and I would like to know what percent of people come three times a week and I don't know how to do this.
If you already have a Pivot Table created, you clearly are not a beginner with Excel. Can the Pivot Table itself be a source of the calculation of percentages that you want?
As I asked first time around, can you post a copy (without real names; maybe just the IDs, but with a few additional characters added) on OneDrive or GoogleDrive. That would help flesh out your description. Just paste a link here to the spreadsheet, a link that grants us edit access.