![]() |
multiple column filtration
is it possible to filter multiple columns at once, maybe with a macro? thanks.
|
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 |
All times are GMT +1. The time now is 03:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com