Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
is it possible to filter multiple columns at once, maybe with a macro? thanks.
|
#2
![]() |
|||
|
|||
![]() Quote:
Sample Database Columns: A | B | C | D | E FirstName | LastName | Age | Height | Weight Robert | Zare | 21 | 180 | 85 . . . . Criteria Columns: Age | Weight 21 | 80 In the Advanced Filter Dialog Box you must provide two sets of values: Data Range: A1:E25 Criteria Range: A30:B31 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"filtration" of dataset | Excel Worksheet Functions | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
Problem when trying to convert one column with multiple rows to one row with multiple column | Excel Programming | |||
filtration of worksheets tallying 2 million seperate phone numbers | Excel Programming |