A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

advanced filter

Thread Tools Display Modes
Old January 13th 06, 03:54 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
Posts: n/a
Default advanced filter

never tried using advanced filter, and am having a bit of difficulty
understading 1) is it my best solution, 2) placement of the different pieces.
Here's my situation:

I have a list of accounts from a chart of accounts. To the right of the
list, I have "1" indicators for several different people (each occupying
his/her own column), with the "1" indicating that the person does or does not
need to use the account listed in the line that the "1" is in. Based on this
1 for each person, I'd like to make named ranges that summarize only the
accounts (with several columns of the data describing each account) that are
relevant for that person. My thought was filtering the list for each
person's set of 1's. So it looks like this:

MajorAcct MinorAcct AcctDesc Acct# Person1 Person2
MajAcctTxt1 MinAcctTxt1 AcctDesc1 Acct1 1
MajAcctTxt2 MinAcctTxt2 AcctDesc2 Acct2 1
MajAcctTxt3 MinAcctTxt3 AcctDesc3 Acct3 1
MajAcctTxt4 MinAcctTxt3 AcctDesc4 Acct4 1

I want a filter that will, in a different place than the original list
(maybe off to the right) show me a subset of the entire list for each person
(so, two subsets), with the basis being that a "1" is listed for that person.
I need, in each subset, to have all four columns of txt show up for each
subset entry.

what I need help on is 1) is advanced filter my answer or is there something
I don't know about that works better, 2) where do I place the cursor to set
up the filter, 3) what are the things I indicate for the filter dialogue that
will get me setup the right way.

Thanks so much. Sorry for all the detail, but I always figure it's better
to explain more than have a request with guessing on the other side about
what it means.
Old January 13th 06, 05:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
Posts: n/a
Default advanced filter

1) Since you want a copy of the list to another place Advanced Filter
is what you seek.
2) Just click anywhere on the list before issuing the
Data|Filter|Advanced filter command.
3) You will need two cells, one over the other, e.g. AA1 and AA2. In
AA1 you should write the label of the column that you want (i.e.
Person3). In AA2 you will write 1.

When you issue the filter, Excel will ordinarily detect the range for
the first textbox. For the second one you will need to select AA1:AA2.
If you check the option to Make a Copy on Another Location, the you can
click anywehre else you want for the 3rd textbox.

Kostis Vezerides


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Filter for exact value hari Excel Discussion (Misc queries) 2 November 10th 05 08:23 PM
Using advanced filter to search for criteria in a list Potatosalad2 Excel Discussion (Misc queries) 1 June 8th 05 03:08 AM
Advanced filter question Heinzpickle Excel Discussion (Misc queries) 3 March 25th 05 04:49 PM
Advanced Filter: No Filter Evan Weiner - Richalnd WA Excel Discussion (Misc queries) 2 December 9th 04 04:36 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM

All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.