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."