Hello my friends, I am new in your community, I would like to ask you for helping. I am sorry for my English.



I just made a sample table with few lists. My biggest problem is, that i would like to find some key, how to select in every row combination -

* in column ´´volno´´ value ´´1´´, in case of vale 1, I would like to copy value in a row ´´name´´ into a list ´´rozpis - yellow marked. Finally I wolud like to have there all the names with value 1. I would like to perform this for every row(date)

* The second question is almost simillar, I would like to extract and copy all the names with value ´´1´´ in column ´´služba´´. These names are divided into two groups of persons - Starší - red (copy into a red cell) and mladší - blue - copy into a blue cell.

Thank you so much for helping, Tomas

Attached Files

Služby.xlsx (24.8 KB, 9 views)