Hi Gord,
I appreciate your reply,
i have a table as below

Student Name Pass/Fail Exam
Manish Fail VB
Gord Pass Java

the above table is an example of my job sheet it has thousands of records i
want to run a macro where i can Delete all the rows for the Students who
gave JAVA exam and failed by a single macro.
i know this can be achived my filtering but then again i have delete the
row after selecting. I want some thing as below.......

if(exam = "JAVA" and Pass/Fail="Fail", then delet the particular row)

I appreciate your help.
Waiting for your response.
Regards,
Manish

"Gord Dibben" wrote:

You will have to.............

1. Use VBA

2. Provide much more detail on particular condition or multiple
conditions.


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 08:36:02 -0700, Manish
wrote:

I want to delet a particular row based on a particular condition which has
multiple conditions.
Please asist ASAP as this will be a great help for me.