| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select rows which satisfy 2 criteria
HI I need to select rows which satisfy criteria contained in 2 different columns. For example , select those rows which have cells in column A with a number below 200 and also have the word 'Green' in column F. The cells should be selected rather than filtered if possible. Grateful any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows that satisfy multiple conditions | Excel Worksheet Functions | |||
| select rows and delete based on criteria | Excel Programming | |||
| Satisfy 2 and more criteria | Excel Worksheet Functions | |||
| Select rows based on criteria | Excel Worksheet Functions | |||
| add a column only if 5 other cells on the row satisfy criteria | Excel Worksheet Functions | |||
Threaded Mode
