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

**trinston** · 03-18-2013, 11:09 AM

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

**Jacc** · 03-18-2013, 12:30 PM

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.