+ Reply to Thread
Results 1 to 5 of 5

Count Nationality by Grade - UserForm List View

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    167

    Count Nationality by Grade - UserForm List View

    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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Count Nationality by Grade - UserForm List View

    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.

  3. #3
    Forum Contributor
    Join Date
    08-19-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    167

    Re: Count Nationality by Grade - UserForm List View

    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

  4. #4
    Forum Contributor
    Join Date
    08-19-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    167

    Re: Count Nationality by Grade - UserForm List View

    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

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Count Nationality by Grade - UserForm List View

    Thank You for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to count matching grade and location
    By dilipsny in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-27-2020, 03:22 AM
  2. [SOLVED] Userform list box view data
    By sabeelahmedks in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2018, 04:19 AM
  3. Inserting Icon in List View VB & Select the coloum value of list view
    By AqieqS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2014, 10:15 PM
  4. [SOLVED] Formula to count grade
    By edmund588 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-29-2012, 12:12 PM
  5. [SOLVED] Issue - replies/view count labels in New Posts view
    By teylyn in forum Suggestions for Improvement
    Replies: 5
    Last Post: 03-16-2012, 05:45 AM
  6. Nationality to country table
    By anderspeders in forum Excel General
    Replies: 1
    Last Post: 08-04-2011, 02:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1