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