Hello,
I am trying to get the Nationality Count by Grade in a list view alphabetically, I achieved getting the Nationality in the list view,
but i unable to get the count by grade.
I appreciate your help in this issue.
Regards
Jude
Hello,
I am trying to get the Nationality Count by Grade in a list view alphabetically, I achieved getting the Nationality in the list view,
but i unable to get the count by grade.
I appreciate your help in this issue.
Regards
Jude
It would seem to me that it would be relatively easy to this using a pivot table.
Select one cell in the data range A1:F97
Press the Alt, N and V keys
Select a location for the pivot table.
From the Field List pull Grade and Nationality into the Rows area and Nationality (a 2nd time) into the Values area.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi ,
The user form is part of many forms and table, i am trying to achieve this without pivot table and any extra report.
Basically trying to get all the reports from one table, i went through lot of examples in this forum similar to this but i couldn't able to get it.
I don't know what i am missing
Hello,
I have found the answer from the below thread by bakerman2 and it sorted now.
https://www.excelforum.com/excel-pro...marked-by.html
Many thanks to bakerman2
Thank You for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks