ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Populating a summary of variable size. (https://www.excelbanter.com/excel-discussion-misc-queries/95468-populating-summary-variable-size.html)

shakey1181

Populating a summary of variable size.
 
I have summarized my table by coloured task [thanks to the xldynamix site!].
I have the time across the top, employee at the side and coloured cells
representing the task type.

If my summary table says at 07:00 there are 4 emps assigned to task1 [which
is simply a coloured cell with no other data in it] How would I then return
the employee names from column A who are assigned to this? The number of
assignments is constantly changing, so the summary table would have to be
able to do this also.

Thanks for any help





All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com