Assuming your data is in columns A through C

Option Compare Text
Sub delete_fails()
Dim rng As Range
Set rng = ActiveSheet.Range(Cells(2, 3), _
Cells(Rows.Count, 3).End(xlUp))
For Each cell In rng
If cell.Value = "Java" And _
cell.Offset(0, -1).Value = "Fail" Then
cell.EntireRow.Delete
End If
Next
End Sub


Gord

On Tue, 9 Jun 2009 10:29:01 -0700, Manish
wrote:

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.