Data filteration based on multiple criteria

S

SGangs

Hi!!
I have a very voluminous data arranged in rows. I would like to have input
mulitple criteria for which the records below should be filtered.
For Example: Row 4 onwards contain (Col A) -Name, (Col B) -Age, (Col C) -
DOJ, (Col D)-Position, (Col E)- Salary
In Row 1 to 3 , i would like to input values like
Name : John Age from : 30 Age To :40 Salary : > 4000 (of course
all these in seperate cells).
I know i can do these using Data filters, but i want to do this by entering
values in cells.
Thanks in Advance

SGangs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Find largest value in column with 2 criteria 1
Transpose Based on Criteria 9
Sum data with multiple criteria 1
Copy paste data from a column to a row 0
FILTERATION ON MULTIPLE CRITERIA OF A COLUMN 2
Working with multiple sheets 8
COUNTIF Function on filtered data 2

Top