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. |
Data filteration based on multiple criteria
Hi,
I guess you are looking for look up formulas this site will help you in this regard. http://www.contextures.com/tiptech.html -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "SGangs" wrote: 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. |
Data filteration based on multiple criteria
Excel 2007
Filter Table four ways: PivotTable, Table, Table (VBA), Advanced Filter (VBA or manual). http://www.mediafire.com/file/1mm0zwknbe2/01_27_09.xlsm |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com