Results 1 to 10 of 10

Top 5 largest results from list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-14-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    125

    Top 5 largest results from list

    I have a list of monthly error types an employee can be written up for. There are several error types (there are about 40 types). These do not change the number/type is static.See below what I am calling Chart one...

    The amount of errors per month do change. I need to be able to add a section to a report displaying what the top 5 error types were number wise for each month.

    I tried using a "large function" which works great to tell me the amount of worst error types for month (for example it looks through the error list and returns these numbers): 33,28,18,14,14. This data is displayed in what I am calling Chart 2 below. So for this example month one error type was reported 33 times, the next worst was 28 reports for another error type etc.

    I then tried to use a VLookup on the results of the Large function (i.e. find in list of ~40 errors the number 30 and return the name of error type listed next to it) but there is a problem ..like the above month there are often duplicate numbers (there were 2 error types that both received 14 reports) for differing error types.Any ideas? Below is example of what I have on report page.

    Chart 1
    Error Type column,Amount column,%Rank column
    ErrorA,x,x
    ErrorB,x,x,

    etc.

    Chart 2
    Amount column, Error Type
    33, Error A
    28, Error G
    18, Error D
    14, N/A
    14,N/A
    Last edited by LiLi1; 08-05-2010 at 05:03 PM. Reason: add information

Thread Information

Users Browsing this Thread

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

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