#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
I am not clearly understanding your desire.
However, I believe that for your second question you want to use the Advanced Filter and use the Option to Copy Results to a new location. The other method available would be to use Power Query. Do not that Filters generally work on Values and NOT Formatting. A Cell's color is a Format and not directly supported as a Filter for Advanced Filter or Power Query. Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria) - YouTube |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Finding a value in one column and in another | itmaster | Excel | 2 | 12-12-2014 10:13 AM |
finding my product key | smithyboy43 | Office | 1 | 10-16-2014 01:23 PM |
I need help finding a easy way to do this | patatesboy | Word | 1 | 01-18-2013 10:02 PM |
finding more the one | gsrikanth | Excel | 0 | 05-14-2012 03:25 AM |
finding paragraphs | sixhobbits | Word | 2 | 06-14-2010 09:48 AM |