View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SGangs SGangs is offline
external usenet poster
 
Posts: 4
Default 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.