Results 1 to 6 of 6

Need help for macros that will provide some statistical information per user name...

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-20-2011
    Location
    liverpool
    MS-Off Ver
    Excel 2016
    Posts
    198

    Need help for macros that will provide some statistical information per user name...

    Hello,
    I have and xls file that consist of 22 columns and might reach up to 20 000 rows.
    The essential part of that xls is:
    * column E-where I have user name
    * column H-where I might have one of the following Categories: "Stype1", "Stype2","Stype3","Stype4", "Qtype"
    * column V-where I have 3 values "OK" or "NOK" or ""(empty, no entry)

    What is needed from the macros agter execution?
    To populate a table located on next sheet where in column A I have list of users and against each user to have the following information:
    *how many categories "Stype1", how many of them are having score "OK" and "NOK"
    *how many categories "Stype2", how many of them are having score "OK" and "NOK"
    *how many categories "Stype3", how many of them are having score "OK" and "NOK"
    *how many categories "Stype4", how many of them are having score "OK" and "NOK"
    *how many categories "Qtype", how many of them are having score "OK" and "NOK"

    In the attached file you will fond a model of the source file (sheet "raw_data" and what is expected to be populated by the macros in sheet "Macros_output"
    Bear in mind that each time macros is run we can have different number if rows and different users

    Thanks in advance for your bright VBA code.
    erkamu
    Attached Files Attached Files
    Last edited by erkamu; 03-24-2017 at 01:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hello and Thanks for all the Great Information you Provide
    By frank_AL in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-30-2015, 02:54 PM
  2. Replies: 7
    Last Post: 05-08-2015, 01:52 PM
  3. Provide list of information if match to the summary
    By dondonordas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 07:44 AM
  4. [SOLVED] Provide user defined function for below vba code
    By tanmanoj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2013, 12:10 AM
  5. Looking for a formula to provide an outcome from a listing of information
    By s.tara91 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-25-2013, 02:27 AM
  6. User to provide input for row to use
    By jlax34 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 11:24 AM
  7. Produce Statistical Information
    By Paul Black in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2006, 04:45 AM

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