Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter formula | Excel Worksheet Functions | |||
Filter formula | Excel Worksheet Functions | |||
Filter, Cell Reference formula and copy formula on filter data | Excel Programming | |||
Filter formula | Excel Worksheet Functions | |||
Formula for Filter | Excel Programming |