I am trying to use excel to run a database(cos i really dont like office) but
i am relatively new to coding.

At the moment I am running a search by filtering the colums to match user
inputted data, I have come accross a problem as I need to search for one
value that can occur in up to 19 columns, but i have to keep every row of
data that it appears in just once.

Any help would be grreatly appreciated
Thank you

In this example, the data is in cols B thru T and in rows 2 thru 100. Put
the match value in A1 and run:

Sub OnlyOneTime()
v = Range("A1").Value
For i = 2 To 100
Set r = Range("B" & i & ":T" & i)
If Application.WorksheetFunction.CountIf(r, v) 0 Then
Rows(i).Hidden = False
Else
Rows(i).Hidden = True
End If
Next
End Sub
--
Gary''s Student - gsnu200825


"Miree" wrote:

I am trying to use excel to run a database(cos i really dont like office) but
i am relatively new to coding.

At the moment I am running a search by filtering the colums to match user
inputted data, I have come accross a problem as I need to search for one
value that can occur in up to 19 columns, but i have to keep every row of
data that it appears in just once.

Any help would be grreatly appreciated
Thank you