+ Reply to Thread
Results 1 to 3 of 3

Extracting/matching row & column data for column greater than 0

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Extracting/matching row & column data for column greater than 0

    Hello,

    First, this forum has been a life saver for some of my vlookup and function woes. I spent some time this morning researching and testing a matching array for my latest problem but can't get it to work and I'm not sure if that is even the correct solution in this case. I know this should be a fairly basic solution so any help would be greatly appreciated.

    My excel workbook is attached, Sheet1 lists my table of data. Column A (Charge #) lists unique number values. Column B - K lists hours associated with each charge number in Column A to each employee name. For example, in Cell B2 - Jake has 0 hours against the Row2 charge number. In Cell B3 Jake has 27 hours against Row3 charge number.

    I am going to have a separate tab for each employee, and pull everything from this table. I want to be able to automatically pull and list only values greater than 0 for each employee, and report those hours along with the associated charge # in column A. I am not sure if I am explaining this well, but an example of what I am trying to automatically report for this example is on the "Jake" tab. Trying to avoid having separate pivot tables and filters for each employee.

    Thank you for any advice.ExcelData.xlsx

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,618

    Re: Extracting/matching row & column data for column greater than 0

    This is how I would do it. Note that I converted your original table to an Excel Table. That way you can expand it as much as you want without having to adapt the formulas. The datavalidation drop down was just for testing but it will expand with the table too if you add more people.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Extracting/matching row & column data for column greater than 0

    Thank you, I tested this and it works! Perfect since I will always need to expand the table for additional people.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1