View Single Post
 
Old 01-15-2022, 09:38 AM
zubrtomas zubrtomas is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2022
Posts: 1
zubrtomas is on a distinguished road
Default Finding comlumns with value

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瀊a创. 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
File Type: xlsx Slu瀊y.xlsx (24.8 KB, 9 views)
Reply With Quote