Filter with an IF, AND, NOT formula
 

I want to filter my Chess database for all 4th Black moves only, prior
to the 5th move,
and copy the whole row result in sheet2

1. d4 Nf6 2. c4 g6
1. d4 Nf6 2. c4 g6 3.Nc3
1. d4 Nf6 2. c4 g6 3.Nc3 d5
1. d4 Nf6 2. c4 g6 3.Nc3 d5 4. cxd5
1. d4 Nf6 2. c4 g6 3.Nc3 d5 4. cxd5 Nxd5
1. d4 Nf6 2. c4 g6 3.Nc3 d5 4. cxd5 Nxd5 5. e4
1. e4 c5
1. e4 c5 2. Nf3
1. e4 c5 2. Nf3 d6
1. e4 c5 2. Nf3 d6 3. d4
1. e4 c5 2. Nf3 d6 3. d4 cxd4
1. e4 c5 2. Nf3 d6 3. d4 cxd4 4. Nxd4
1. e4 c5 2. Nf3 d6 3. d4 cxd4 4. Nxd4
Nf6
1. e4 c5 2. Nf3 d6 3. d4 cxd4 4. Nxd4 Nf6 5. Nc3
from the above example, the following rows would be returned :
1. d4 Nf6 2. c4 g6 3.Nc3 d5 4. cxd5 Nxd5
1. e4 c5 2. Nf3 d6 3. d4 cxd4 4. Nxd4 Nf6
All the above are in Column "A"
..
So far, I have only the beginning of the solution with an Excel
formula,
that is if found "4." and not found "5." copy row to sheet2
I need to go beyond this formula with IF, AND,
NOT
=IF(ISERROR(FIND("4.",A1)),0,"4")
Help appreciated

Filter with an IF, AND, NOT formula
 

On Nov 21, 12:34*pm, u473 wrote:
I want to filter my Chess database for all 4th Black moves only, prior
to the 5th move,
and copy the whole row result in sheet2

1. d4 *Nf6 * 2. c4 g6
1. d4 *Nf6 * 2. c4 g6 *3.Nc3
1. d4 *Nf6 * 2. c4 g6 *3.Nc3 *d5
1. d4 *Nf6 * 2. c4 g6 *3.Nc3 *d5 * 4. cxd5
1. d4 *Nf6 * 2. c4 g6 *3.Nc3 *d5 * 4. cxd5 *Nxd5
1. d4 *Nf6 * 2. c4 g6 *3.Nc3 *d5 * 4. cxd5 *Nxd5 * 5. e4
1. e4 *c5
1. e4 *c5 *2. Nf3
1. e4 *c5 *2. Nf3 *d6
1. e4 *c5 *2. Nf3 *d6 * 3. d4
1. e4 *c5 *2. Nf3 *d6 * 3. d4 *cxd4
1. e4 *c5 *2. Nf3 *d6 * 3. d4 *cxd4 * 4. Nxd4
1. e4 *c5 *2. Nf3 *d6 * 3. d4 *cxd4 * 4. Nxd4
Nf6
1. e4 *c5 *2. Nf3 *d6 * 3. d4 *cxd4 * 4. Nxd4 *Nf6 * 5. Nc3
from the above example, the following rows would be returned :
1. d4 *Nf6 * 2. c4 g6 *3.Nc3 *d5 * 4. cxd5 *Nxd5
1. e4 *c5 *2. Nf3 *d6 * 3. d4 *cxd4 * 4. Nxd4 *Nf6
All the above are in Column "A"
.
So far, I have only the beginning of the solution with an Excel
formula,
that is if found "4." and not found "5." copy row to sheet2
I need to go beyond this formula *with IF, AND,
NOT
=IF(ISERROR(FIND("4.",A1)),0,"4")
Help appreciated

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."