+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Problem in Data Analysis and Ranking

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    2

    Problem in Data Analysis and Ranking

    Dear Recipients,

    I am stuck with a file where I need to find a result. Itís a big file and the main problem is itís a system generated excel file. And I need to refresh the data after every 30 mins. I hope u can help me out.

    What I want:
    1. I want to find the total of the each column Header Like:"Answdcalls". Although there is a row for that against each Agent name, but the problem is the row change as the data is refreshed.
    2. I want to rank the column total data to top 5 and lowest 5. For example: top 5 answdcalls.

    Please check the attached file, itís the raw system generated data. Please help me out of this.
    Attached Files Attached Files
    Last edited by imran9171; 11-13-2011 at 04:06 PM. Reason: Subject problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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