+ Reply to Thread
Results 1 to 8 of 8

Populate EMP ID's & Count

  1. 11-21-2015, 11:27 AM #1
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Populate EMP ID's & Count

    Hello Everyone..

    I need to track the count of EMPID in one column & wat are the EMP ID in other column..


    INput sheet have

    EMPID, CLASS, Result

    Now depending on Class... We have to track the count of EMPID's & Wat are EMP ID's..

    Example..

    IF
    Class ÄA1"have 4 EmpID's then
    Count of ID's will be 4 & the other column will have all that 4 empid's together.. example (757, 1118, 1306, 1396)

    Plz Assist...


    Any Formula or VBA code..
    Attached Files Attached Files
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html
    Reply With QuoteRegister To Reply
  2. 11-21-2015, 12:57 PM #2
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Populate EMP ID's & Count

    With VBA

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-23-2015, 08:32 PM #3
    kalavatiaai
    kalavatiaai is offline
    Registered User
    Join Date
    11-22-2015
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    8

    Re: Populate EMP ID's & Count

    With the same line for the code provided by Vraag, I need the code which will give the pass output differently and failed output differently.

    Please note - In the result column, there can be different values as well like pass, fail, N/A, Not Eligible etc...

    I need count of EMPID in one column & wat are the EMP ID in other column for their respective result column
    Thanks Vraag for your code, that helped me too but i need the pass, failed, N/A out differently
    Reply With QuoteRegister To Reply
  4. 11-23-2015, 08:58 PM #4
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Populate EMP ID's & Count

    Hi Galatia

    Welcome to the Forum!!!

    Please take a moment to read the Forum Rules...Rule 2...

    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.
    Create a link to this Thread if you feel it's appropriate. Thanks.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  5. 11-23-2015, 10:12 PM #5
    kalavatiaai
    kalavatiaai is offline
    Registered User
    Join Date
    11-22-2015
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    8

    Re: Populate EMP ID's & Count

    Thanks jaslake, I have created a new post for my requirement.
    My concerns was, what i thought was creating a new post with same line will unnecessary create a new forum and my requirement was inline with what Vraag had already provided in his code with some minute changes.
    Anyways thanks for your response. below is the link for my requirement.

    http://www.excelforum.com/excel-prog...ml#post4248112
    Reply With QuoteRegister To Reply
  6. 11-24-2015, 05:28 AM #6
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Populate EMP ID's & Count

    Hello KalavatiAai,

    PLease use code tags... & then post your code in it

    Coming to the requirment the data is calculated in Output sheet on the basis of Input sheet column J as a whole..

    u want the output columns different on the basis of Result (Column J)..... me stuck on this...
    Reply With QuoteRegister To Reply
  7. 11-24-2015, 06:29 PM #7
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Populate EMP ID's & Count

    @Parth007,
    My code has solved your problem?
    Reply With QuoteRegister To Reply
  8. 11-25-2015, 12:58 AM #8
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Populate EMP ID's & Count

    Hi Vraag,

    Yes it did solve my problm.. tested ok..
    Thanks for it
    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)

Similar Threads

  1. [SOLVED] Populate count of values in a Column of all files in one file
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2015, 06:28 AM
  2. Need a formula that will count cells and populate a percentage
    By waldock9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2013, 04:51 AM
  3. count values in a column and populate table
    By Harrison_VBA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2013, 07:31 PM
  4. [SOLVED] Help with using VBA to populate columns matching date with a count/sum
    By compto in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2012, 09:24 AM
  5. VBA Program to Count and populate a table
    By Dohko in forum Excel General
    Replies: 3
    Last Post: 10-18-2010, 11:12 AM
  6. Count Rows and Use to Populate Range
    By SyracuseSteve in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2010, 07:51 PM
  7. used row count in worksheets to populate TOC
    By ajay1967 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2009, 11:24 PM

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