+ Reply to Thread
Results 1 to 7 of 7

Need a List of Persons who take advance

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    9

    Need a List of Persons who take advance

    Dear Experts,
    I need your help.

    I have a salary sheet in which their all record entered monthly. Employees take advances and it's different in every month. means an employee take advance in January but not in February.
    I want to generate a list of person who take advances. like in attached files. It can be done by manually but I want to do this automatically. Hope you understand my problem. Please help.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by amjadayub; 04-08-2014 at 10:13 AM.

  2. #2
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Need a List of Persons who take advance

    Used helper column
    f3 =IF(E3>0,ROW()-2,"") drag down

    h5 =IFERROR(INDEX($A$3:$E$11,SMALL($F$3:$F$11,ROWS($G$4:G4)),MATCH(H$4,$A$2:$E$2,0)),"") Ctrl+Shift+Enter
    Attached Files Attached Files
    Appreciate the help? CLICK *

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Need a List of Persons who take advance

    Maybe this could solve.....
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Need a List of Persons who take advance

    Formula below is without helper column. Its an array formula (CSE). Paste to H5 cell
    =IFERROR(INDEX($A$3:$E$11,MATCH(0,COUNTIF($K$4:K4,$E$3:$E$11)+ISBLANK($E$3:$E$11),0),MATCH(H$4,$A$2:$E$2,0)),"")

    Firstly drag right then down

  5. #5
    Registered User
    Join Date
    09-08-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Need a List of Persons who take advance

    Very Helpful
    Thanks a lot

  6. #6
    Registered User
    Join Date
    09-08-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Need a List of Persons who take advance

    Quote Originally Posted by azumi View Post
    Maybe this could solve.....
    Very Helpful
    Thanks a lot

  7. #7
    Registered User
    Join Date
    09-08-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Need a List of Persons who take advance

    Quote Originally Posted by AZ-XL View Post
    Used helper column
    f3 =IF(E3>0,ROW()-2,"") drag down

    h5 =IFERROR(INDEX($A$3:$E$11,SMALL($F$3:$F$11,ROWS($G$4:G4)),MATCH(H$4,$A$2:$E$2,0)),"") Ctrl+Shift+Enter

    Thanks
    An easy solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove a List of Persons from a Larger List
    By criticalslinky in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-10-2024, 02:47 PM
  2. [SOLVED] How to replace a list of user names with the persons actual name
    By Chrisg399 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2014, 05:59 AM
  3. [SOLVED] Conditional sorting and make a list using advance filter
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2013, 12:31 PM
  4. Dividing a value list equall among multiple persons
    By bf44qv1 in forum Excel General
    Replies: 2
    Last Post: 03-08-2006, 09:35 AM
  5. [SOLVED] Code to Advance filter a list in a shared workbook
    By ram in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2006, 10:50 PM

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