List Manager query

  • Thread starter Thread starter Ntisch
  • Start date Start date
N

Ntisch

This is my first post so I hope this question has not been poste
before.

I use Excel in the Macintosh Os X environment.

I have descending date data in column A,. In columns B ,C, D etc I hav
different name data. What I would like to do is to create a list
across the different columns (B,C,D etc) from which I can select dat
from within those columns. In effect, I am trying to extend the lis
manager function across different columns. In this way I would like t
have like a master list drop down menu, containing the data from th
different columns, which I can use to display the different dat
(simultaneously), not just a column at a time as the standard lis
manager does. Do you know is this possible using the list manage
function?

thanks, Ni
 
I'm unclear on what you're trying to do. If you select columns A to D
and Insert a List, each column will have its own autofilter dropdown,
though they are cumulative rather than individual.

Perhaps if you gave a more detailed example, it would be possible to
recommend a solution...
 
Thanks for your reply.

In column A I have descending date data.

In columns B, C, D I have name data. Some of the columns share the sam
data, eg the word entry 'venue' appears in columns B and C and D
though on different dates.

What I would like to do is make a list that filters columns B, C,
that will give me the option to select the word entry 'venue' an
create a list, across columns B, C, and D. The resulting list woul
show the word entry 'venue' on different dates across differen
columns.

I ask this as currently I am unable to make a list across columns, onl
within columns
 
You can't, AFAIK, do this within List Manager. One workaround:

Assuming your data starts in row 2, try adding a 5th column with the
formula

E2: =COUNTIF(B2:D2,E$1)

copied down. Then enter your criterion (e.g., "venue") in E1 and filter
on TRUE in column E.
 
Thanks for that.

The formula I understand. What I don't know how to do is apply the
filter you describe and get the result. If you would please let me know
if this is an advanced or auto filter and how to program the crtierion
to get the result.
 
I was speaking of an autofilter with the criterion TRUE, selected from
the dropdown.
 
Back
Top