Filter with an IF, AND, NOT formula

  • Thread starter Thread starter u473
  • Start date Start date
U

u473

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
 
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
Click to expand...

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