Are these homework questions?

Q1, Q2 & Q3 can be done using Autofilter Custom

Q4 can be done using a Helper column & Autofilter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...

Hi! can anyone tell me the ans for the following questions in
excel...........


Assume that there is a student table with the following attributes
Name, stu Id , marks,(Assume that there are 500 students or columns)

Q1. Student name starts with R
Q2. marks which are less than 80
Q3. Marks which are greater than 50
Q4. Student name which has E in their Name?..............