CODEWITHSUNDEEP
excel
user321627
user321627

Reputation: 2564

In excel, how can you search for text matching multiple column entries?

Currently in excel, I have columns and rows that look like the following:

           Person 1 Person 2    Person 3    Person 4    Person 5
Condition 1      F       T             F           F           F
Condition 2      F       T             T           F           F
Condition 3      F       F             T           T           F
Condition 4      F       F             F           F           T
Condition 5      F       F             F           F           F

For each person, they have a 5 valued vector of True/False entries for each of 5 conditions. Currently, I have about 50 people, and it becomes a nightmare to manually find the ones matching a 5 valued vector I want. For example, I would like to find the Person matching FTTFF, which is person 3.

I am wondering if there is a way in excel to quickly identify which columns contain the string, read vertically? thanks.

Upvotes: 0

Views: 69

Answers (1)

Hila DG
Hila DG

Reputation: 728

The best way would be to add another column which would be concatenation of columns 1 & 2 & 3 & 4 & 5 (use the & sign to concatenate text)
so for person 3 you'd get FTTFF and for person 1 you'd get FTFFF
and then you filter by that new column

Upvotes: 2

Related Questions