LFAssisReq
New Member
- Joined
- Jul 14, 2011
- Messages
- 1
Hi I am having trouble coming up with a formula to do the following
I have a table with a variety of information
Column A contains the values for X
Column B contains the values for Y
Column C gives a name
You can have the same name multiple times with various values in column B.
I would like to extract/ display the entire row where Y > 1.
Here's the caveat, where the row contains Y > 1 I too want to extract all the rows for this particular person (column C) including the row that contains the value Y= 1 for this person.
The idea is where this person has values greater than 1 in column B we would like to know what they were doing where they had a value of 1 as well.
I hope that makes sense. I would appreciate any assistance.
I have a table with a variety of information
Column A contains the values for X
Column B contains the values for Y
Column C gives a name
You can have the same name multiple times with various values in column B.
I would like to extract/ display the entire row where Y > 1.
Here's the caveat, where the row contains Y > 1 I too want to extract all the rows for this particular person (column C) including the row that contains the value Y= 1 for this person.
The idea is where this person has values greater than 1 in column B we would like to know what they were doing where they had a value of 1 as well.
I hope that makes sense. I would appreciate any assistance.
