title: filter my array on column 3 for a specific word
body: <p>I have the following code below,</p>
  
  <p>I want to filter the array (not the sheet) for the word "phone" which sits in column 3 of the array. The output would then go to my destination sheet("L")</p>
  
  <p>how would i modify the code below to filter for the word? I must state i want to filter the array not the sheet.</p>
  
  <pre><code>Sub Example1()
  Dim arrValues() As Variant
  Dim lastRow As Long
  Dim filteredArray()
  Dim lRow As Long
  Dim lCount As Long
  Dim alength As Long
  lastRow = Sheets("Raw Data").UsedRange.Rows(Sheets("Raw Data").UsedRange.Rows.Count).Row
  arrValues = Sheets("Raw Data").Range(Cells(2, 1), Cells(lastRow, 21)).Value
  ReDim filteredArray(1 To UBound(arrValues), 1 To 1)
  alength = UBound(arrValues)
  For lCount = 1 To UBound(arrValues) Step 1
     lRow = lRow + 1
     filteredArray(lRow, 1) = arrValues(lCount, 1)
  Next
  Sheets("L").Range("A2:U" &amp; 1 + alength) = filteredArray
  End Sub
  </code></pre>