[qqplus]

Dear Techies,

A Very Happy New Year to you!

I need help in MS Excel. To tell you quickly the situation that I have got,

I have a list of 40-50 tasks, each having different time required for execution. E.g. task A requires 15 minutes, task b 20 and so on at random. There are some other attributes to those tasks like equipment required etc.

Now, I want to know a way by which I can fetch tasks matching certain given criteria, onto the other sheet. For example, If I input time available as 20, it should give me the tasks which can be completed in 20 minutes or less.

Can anyone assist me with that?

Kind Regards,
AJ
http://ajstates.blogspot.com

[Keebellah]

Hi AJ,
The quickest way is a pivot table then you can filetr time value and you have your results