+ Reply to Thread
Results 1 to 4 of 4

Analyse Data in a Row

  1. 10-22-2008, 02:55 AM #1
    NeedHelpFast
    NeedHelpFast is offline
    Registered User
    Join Date
    10-22-2008
    Location
    New York
    Posts
    2

    Question Analyse Data in a Row

    I have a sheet that has EMPLOYEE NAMES in Column A.
    Across in the ROWS is the technical skills and their level of proficiency.
    Once all the data is entered I need to consolidate all the data as a summary sheet for all the technologies. Attaching a file for details.
    The 2nd sheet has the data that needs to be analysed. The first sheet is where the totals are needed.
    Any help is appreciated. Thanks in advance to all the EXCEL Gurus.
    Attached Files Attached Files
    Last edited by NeedHelpFast; 10-23-2008 at 06:06 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 10-22-2008, 05:53 AM #2
    analyst1012
    analyst1012 is offline
    Registered User
    Join Date
    10-07-2008
    Location
    india
    Posts
    11
    hi
    you can use "=countif()" formula, to count. for instance enter "=COUNTIF('Technical Skill Set'!C3:C8,"H")" formula in the firstsheet to get the number of high for Java/J2EE.

    rgds
    Reply With QuoteRegister To Reply
  3. 10-22-2008, 06:20 AM #3
    ravishankar
    ravishankar is offline
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    macro

    HI
    run the macro in the attached spreadsheet. it inserts countif formula to calculate the needed data
    ravi
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-23-2008, 06:05 AM #4
    NeedHelpFast
    NeedHelpFast is offline
    Registered User
    Join Date
    10-22-2008
    Location
    New York
    Posts
    2

    Thanks

    Awesome!!! I knew EXCEL was cool at these formulas but never thought it would be so easy. Thanks a lot chief.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1