Author Posts

August 21, 2014 at 7:46 am

Hello, i have a scrip that is data mining in Excel. I need to filter a column based on multiple data, sometimes, two, or maybe more data. i have tried many different methods and i either get only the last value in the array. or an error – {Exception calling "Autofilter" with "3" arguments(s): "Autofilter method of Range class failed". Please help. I have found nothing on the Thanks , Jeff W. 
——————————————————————————–

Jeffrey I Wilson
[#filter for column
$FL = @("lastname, first","lastnamedif, firstnamedif")
$rng=$Worksheet.cells.item(2,38).entirecolumn
$rng.select | Out-Null
$excel.Selection.AutoFilter]

August 21, 2014 at 11:38 am

The autofilter method can take up to five parameters. Have you tried using $null for the parameters that you are not using, so you are always passing five parameters into the method?

e.g.

Filter the first column of the select range so that it only lists items which a value of 'FilterMe'

$excel.Selection.AutoFilter(1, 'FilterMe', 1, $null, $null)

August 26, 2014 at 8:15 am

Ok, but how can i choose two items, such as "filter me" and job,bob from the same column???
Thanks in advance.
Jeff W.

April 4, 2018 at 3:35 am

In that case use advance filter

April 4, 2018 at 3:37 am

Use advance filter using criteria range and filter type