Multiple criteria on an Autofilter from a singe cell

Blunder1

Active Member
Joined
Jun 2, 2010
Messages
250
Hi,

I'm trying to add to my code an autofiler with multiple criteria, the criteria is held in single cell. The criteria is made up of anything from 5 to 30 cells, then i have tried to concatentate these separated by commas, in speech marks, speech marks and commac etc, set them as an array the use that in my filter, but nothing seems to work.

Can anyone help how to do this?

Thanks in advance

Blunder
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
how is the cell with the criteria formatted the values are separated by commas??
and in which cell is it?
 
Upvote 0
Can this Filter method be used to sort out Unique entries, by acct nbumber, then by most columns filled in with data amoung the duplicate acct numbers?

For example: 2 rows with the same acct #, one row has 10 columns of text and the other only 5. - How could I get excel to filter for rows with the most columns filled in?
 
Upvote 0
Can this Filter method be used to sort out Unique entries, by acct nbumber, then by most columns filled in with data amoung the duplicate acct numbers?

For example: 2 rows with the same acct #, one row has 10 columns of text and the other only 5. - How could I get excel to filter for rows with the most columns filled in?

are you in the wrong thread???
 
Upvote 0
The range will be G1 to say G15 and will contain text similar to the below
ABC123
ABC124
ABC125
ABC126
ABC127
ABC128
ABC129
ABC130
ABC131
ABC132
ABC133
ABC134
ABC135
ABC136
ABC137

<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>

then i have created in cell H1 the below:
"ABC123","ABC124","ABC125","ABC126","ABC127","ABC128","ABC129","ABC130","ABC131","ABC132","ABC133","ABC134","ABC135","ABC136","ABC137"

<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>

the tried tried to use that cell in the autofiler:-
activesheet.usedrange.AutoFilter Field:=4, Criteria1:=Array(Range"H1").value), Operator:=xlFilterValues
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top