| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data filteration based on multiple criteria
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| How do I retrieve data based on multiple search criteria? | Excel Worksheet Functions | |||
| How do I retrieve data based on multiple search criteria? | Excel Worksheet Functions | |||
| Paste data based on multiple criteria | Excel Worksheet Functions | |||
| FILTERATION ON MULTIPLE CRITERIA OF A COLUMN | Excel Discussion (Misc queries) | |||
Threaded Mode
