#### mdorman

##### New Member

- Joined
- Jan 27, 2005

- Messages
- 23

Problem.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | |||

1 | Start | Finish | Criteria List | or | Criteria List | |||||

2 | #1 | ape | 1 | 4 | 1 | |||||

3 | bear | 3 | 6 | 0 | ||||||

4 | cat | 1 | 3 | 1 | ||||||

5 | dog | 8 | 5 | 0 | ||||||

6 | 2 | 2 | ||||||||

7 | ||||||||||

8 | Start | Finish | Criteria List | or | Criteria List | |||||

9 | #2 | ape | 1 | 4 | ape | ape | ||||

10 | bear | 3 | 6 | FALSE | ||||||

11 | cat | 1 | 3 | cat | cat | |||||

12 | dog | 8 | 5 | FALSE | ||||||

13 | ||||||||||

14 | Start | Finish | Criteria List | |||||||

15 | #3 | ape | 1 | 4 | ape | |||||

16 | bear | 3 | 6 | cat | ||||||

17 | cat | 1 | 3 | |||||||

18 | dog | 8 | 5 | |||||||

Sheet2 |

#1 & #2 above are a given (even for me), but i'd like to get to #3 which generates a list which excludes returned values that don't meet the given criteria. I hope the example helps.

Surely there is a way to accomplish this in excel using an array formula (or other method)????

Any help is greatly appreciated...