I want to use a named range, which is a single value as the "equal to"
criteria in the advanced filter dialog box.

I have a named range of a single cell I call "FlicNum".

I have a list of 'flicnums' and actor numbers. With over 130 thousand
DVDs in the main list, the actor list index is about 660 thousand records
long.

If I filter on "FlicNum" I should only see a list of actor numbers that
tie to that FlicNum. That is the goal. Getting the filter to accept my
"variable" is the obstacle.

If I enter a 'flicnum' (DVD ID number) by hand, it filters on it just
fine. How do I plug in a "variable", or named range into a filter dialog
or specification?

Describe everything you have. When you apply the filter what's the criteria
range, what is in the criteria range, what are the headers in your table
etc.

When I create a test table, with the headers Flicnum and Actornum, put some
data in there, then use H1:H2 as criteria range with Flicnum in H1 and
=Flicnum in H2 it filters fine, when I change the value in the named cell
called Flicnum and refresh the filter it works fine and filter for the new
value
--


Regards,


Peo Sjoblom


"Pieyed Piper" g wrote in
message ...


I want to use a named range, which is a single value as the "equal to"
criteria in the advanced filter dialog box.

I have a named range of a single cell I call "FlicNum".

I have a list of 'flicnums' and actor numbers. With over 130 thousand
DVDs in the main list, the actor list index is about 660 thousand records
long.

If I filter on "FlicNum" I should only see a list of actor numbers that
tie to that FlicNum. That is the goal. Getting the filter to accept my
"variable" is the obstacle.

If I enter a 'flicnum' (DVD ID number) by hand, it filters on it just
fine. How do I plug in a "variable", or named range into a filter dialog
or specification?

On Tue, 10 Nov 2009 08:47:15 -0800, "Peo Sjoblom"
wrote:

Describe everything you have. When you apply the filter what's the criteria
range, what is in the criteria range, what are the headers in your table
etc.

When I create a test table, with the headers Flicnum and Actornum, put some
data in there, then use H1:H2 as criteria range with Flicnum in H1 and
=Flicnum in H2 it filters fine, when I change the value in the named cell
called Flicnum and refresh the filter it works fine and filter for the new
value

I have two columns One is headered "ID" the other "ActorNumber".

"FlicNum" comes from another worksheet, but I can replicate it in this
worksheet, though it should not be required.

I made the range into a "table". To use advanced filters on the table,
I can manually enter any number to sort on, and the list sorts to only
entries with that number just fine. It appears like a worksheet that only
has those few records (rows).

I want to be able to plug that sort criteria number into the sort
dynamically. based on the FlicNum "variable" I create on the other sheet.

So far, manual filtering works fine.

Is everyone asleep?


On Wed, 11 Nov 2009 04:49:07 -0800, Pieyed Piper
g wrote:

On Tue, 10 Nov 2009 08:47:15 -0800, "Peo Sjoblom"
wrote:

Describe everything you have. When you apply the filter what's the criteria
range, what is in the criteria range, what are the headers in your table
etc.

When I create a test table, with the headers Flicnum and Actornum, put some
data in there, then use H1:H2 as criteria range with Flicnum in H1 and
=Flicnum in H2 it filters fine, when I change the value in the named cell
called Flicnum and refresh the filter it works fine and filter for the new
value

I have two columns One is headered "ID" the other "ActorNumber".

"FlicNum" comes from another worksheet, but I can replicate it in this
worksheet, though it should not be required.

I made the range into a "table". To use advanced filters on the table,
I can manually enter any number to sort on, and the list sorts to only
entries with that number just fine. It appears like a worksheet that only
has those few records (rows).

I want to be able to plug that sort criteria number into the sort
dynamically. based on the FlicNum "variable" I create on the other sheet.

So far, manual filtering works fine.

Excel 2007 Advanced Filter
Nothing new here.
Did it in my sleep.
http://www.mediafire.com/file/gmvzyz0mzgt/11_14_09.xlsm

On Sat, 14 Nov 2009 17:12:44 -0800 (PST), Herbert Seidenberg
wrote:

Excel 2007 Advanced Filter
Nothing new here.
Did it in my sleep.
http://www.mediafire.com/file/gmvzyz0mzgt/11_14_09.xlsm


That is nice, and thank you very much for your work, but is there no
way to perform these list generations without macros?

On Sat, 14 Nov 2009 17:12:44 -0800 (PST), Herbert Seidenberg
wrote:

Excel 2007 Advanced Filter
Nothing new here.
Did it in my sleep.


I didn't say it was an advanced, advanced filter question. :-)

The director lookup is a simple vlookup, since there is only one per
movie.

The actor listing is what I am after. It is a one-to-many database
operation I am asking for in a spreadsheet... I know.

Thanks for your help.

Here is my screenshot. It is now updated to a single DVD list instead
of the three section list I am almost done with it:

http://i255.photobucket.com/albums/h.../screensht.jpg