Hi
I have a spreadsheet with two sheets
Sheet One is a number of columns with various information and is feed from a SharePoint site , one column is Dept
The second sheet is will be a Summary sheet and initially I want for to list the number of depts ie
IE
Dept A - 16
Dept B - 7
and so on
Once that is sorted I hope ot do basic reporting for each dept using countif
Regards
John Berman
Sounds good
What's your question?!
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I'm not even sure what you're asking
ahh first lesson be clear
How do I achieve the Summary I need as in what function can look at the column labelled Dept and count the occurrences and display by Dept.
John B
Did you try that? or perhaps take a look at countifS()?Once that is sorted I hope ot do basic reporting for each dept using countif
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try
Formula:
Please Login or Register to view this content.
This relies on you already knowing the department name you want to count.
You could also try pivot tables...
Sounds like a pivot table, but not 100% understanding what you mean. Could you upload the file?
Ok a fuller description
The spreadsheet its self is linked to sharepoint and that's were the data is input, so reporting needs to be dynamic as the spreadsheet content will be added to over time.
I have uploaded the xls and on the Summary Sheet shown what I want to achieve - I have added notes
Ideally all management would need to do is open the xls and see the summary report
Regards
John B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks