Menu

multiple column filtration

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

apr pillai apr pillai is offline

apr pillai is offline

Junior Member

Location: India

Posts: 1

Send a message via Yahoo to apr pillai

Send a message via Skype™ to apr pillai

Default

Quote:

Originally Posted by

View Post

is it possible to filter multiple columns at once, maybe with a macro? thanks.

If the Columns are organized in the form of a database then you can use the Advanced Filter Option from Data Menu to filter data on multiple columns.

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 With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"filtration" of dataset	gordom	Excel Worksheet Functions	6	January 6th 09 01:32 AM
Adding multiple values in one column based on multiple values of the same value (text) in another column	[email protected]	Excel Discussion (Misc queries)	1	May 16th 07 06:02 PM
Display multiple lines of text within a cell from multiple column.	Zeeshan Zaheer	Excel Worksheet Functions	3	August 23rd 06 10:08 AM
Problem when trying to convert one column with multiple rows to one row with multiple column	marcello	Excel Programming	1	February 23rd 04 03:03 AM
filtration of worksheets tallying 2 million seperate phone numbers	dabliss74	Excel Programming	1	October 21st 03 06:03 PM

All times are GMT +1. The time now is 10:20 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement