title: powershell, excel,autofilter , not equal
body: <p>How do I exclude only 1 item out of say 7? instead of choosing 6 of them.. The above "clears" the column..
  Looking at the Custom Auto Filter from Excel....</p>
  
  <ul>
  <li>Item1 = X </li>
  <li>Item2 = X</li>
  <li>Item3 = X</li>
  <li>Item4 = X</li>
  <li>Item5 = X</li>
  <li>Item6 =</li>
  <li>Item7 = X</li>
  </ul>
  
  <p>Where the x represents the check box in Excel.</p>
  
  <p>How do i automate this, "reverse" choice, or NOT Equal Too....
  Looking at the Custom AutoFilter, how do I automate, </p>
  
  <ul>
  <li>does not equal  {Item6}</li>
  </ul>
  
  <p>One last item, this must be in Powershell code, NOT VB, or C#, or Excel Macro....</p>
  
  <p>$$<strong>Jiw</strong>@@</p>