davidboulware
New Member
- Joined
- Dec 13, 2006
- Messages
- 19
Needing help with a formula to return true answers in a list. I a column of data and a seperate column with IF formulas to return true or false based on check boxes I've made. I am trying to write a formula that will list all text from the true columns in one list without gaps. Ex:
A1 Mike
A2 Dave
A3 Bill
A4 Steve
A5 Rob
A6 Doug
A7 Jeff
A8 John
A9 Mark
With check marks by Dave, Rob and Mark, I have a seperate return column that returns these true answers. However, they are returned on B2, B5 and B9. I want these responses to return in adjoining cells B1,B2 and B3.
I have a formula that returns the first of the true answers, but can't find a formula to find the second or next true answer. Any suggestions?
A1 Mike
A2 Dave
A3 Bill
A4 Steve
A5 Rob
A6 Doug
A7 Jeff
A8 John
A9 Mark
With check marks by Dave, Rob and Mark, I have a seperate return column that returns these true answers. However, they are returned on B2, B5 and B9. I want these responses to return in adjoining cells B1,B2 and B3.
I have a formula that returns the first of the true answers, but can't find a formula to find the second or next true answer. Any suggestions?
