Okay, I'm pretty good with Excel now, but there is on problem I'm having. How do I search a list (or array) for certain values, then extract those values to another list? For instance, suppose I have the following in cells A1:B7=
No A
No B
Yes C
No D
No E
Yes F
No G
And I want to end up with:
In cell C1: C
In cell C2: F
All I want to do is extract the "Yes" values and put them in a row or column one after the other, without blank cells. I also need to do this with a formula as opposed to filtering or writing a macro. Any help would be appreciated.
Mike
No A
No B
Yes C
No D
No E
Yes F
No G
And I want to end up with:
In cell C1: C
In cell C2: F
All I want to do is extract the "Yes" values and put them in a row or column one after the other, without blank cells. I also need to do this with a formula as opposed to filtering or writing a macro. Any help would be appreciated.
Mike