Populating row headers based on column values

[Jonam711]

Hey guys - I'm working on a daily report were 20 employees update their daily data in sheet 1 following are the column headers in sheet 1"status" drop down list - pending, processed, on hold. the sheet has other columns such as Date when assigned, completed date, no of days pending or on hold. By the end of the day one has to publish the pending/on hold count of each employees based on days range as shown in the attached image (sheet 2). The formulas I put in sheet 2 are working fine. But how it's done now is I have made a list of all the 20 employees and I used "SORT" for that list so all the 20 emps names comes up and we manually delete the rows of employees who don't have any pending counts in any of the days bucket. If you see out of 20 employees only let's say 7 employees have pending/on hold under their names and I need to populate only those 7 employees in a column and show their pending counts.

 

[Jonam711]

Hi,

maybe I didn't understand what you are asking.. You asked for the names and values of those who had total sum >0 in your table C18:G22.

So the formula I have placed in B25 provides the names, and values of all those in the table that are total>0. The values are shown after the names ?

what did I miss here ?

thanks
Rob

Hello - I get only the names whose values had total sum >0, their values not pulling up

 

[RobP]

Ok, I don’t understand why that would be, so you will probably need to share the formula that you use to populate your values , and also how your data is laid out so we can see how the formula is interacting with it.
thanks
Rob

 

[Jonam711]

Left table is base table

 

[RobP]

And the formula in c38 etc. is what ? And the data that formula interacts with is laid out how ?

 

[Jonam711]

And the formula in c38 etc. is what ? And the data that formula interacts with is laid out how ?

Hello - Sorry Rob for the delay, basically the idea is to get the count of pending/on hold requests for every associate based on their how long they are pending (day bucket) let me give you a picture what are the columns that I used in the cells C38 etc, Sheet Data column F - the associates names, column D - dates, column S - status of a request which are pending or on hold, Column AE - the days it's been in pending/on hold.