Muliple statuses for all clients rows = completed

[markhay]

Hi,

Really struggling with a bit of a "minging" spreadsheet.. Each client has multiple rows (1 for each claim) and each row has 2 status fields (I2... and K2...) Theres a unique ref in column B which shows if they relate to the same client.

I need to identify/filter the clients that have a status of completed for both status columns on every one of their rows so I can do some system updates...

I'm using excel 2003 so can't do anything too shiny and its about 10,000 rows so really dont want to go through it manually!

Please Help!

 

[storm8]

if I understand your question correctly you want to filter excel spreadsheet by multiple criteria in different columns. By default this is not really possible, however it can be done trough vba:

Sub test()
    For rw = 1 To 10000
        If Cells(rw, 5) = "x" And Cells(rw, 6) = "y" Then
            Rows(rw).EntireRow.Hidden = True
        End If
    Next rw
End Sub

this is a very simple sub that will hide each row between row 1 and 10000 that has "x" in column 5 and "y" in column 6. If you are unable to modify it to suit you, please provide sample of your data

 

[markhay]

if I understand your question correctly you want to filter excel spreadsheet by multiple criteria in different columns. By default this is not really possible, however it can be done trough vba:

Sub test()
    For rw = 1 To 10000
        If Cells(rw, 5) = "x" And Cells(rw, 6) = "y" Then
            Rows(rw).EntireRow.Hidden = True
        End If
    Next rw
End Sub

this is a very simple sub that will hide each row between row 1 and 10000 that has "x" in column 5 and "y" in column 6. If you are unable to modify it to suit you, please provide sample of your data

sorry, any way i can add an attachment here? :s

 

[storm8]

its somehow possible, but try dropbox or something