software

Column A contains a list of strings, under the heading quot;thingquot;. Next
to each string, Column B contains blanks or an quot;xquot;, with a date as a
heading. In another worksheet, I want to create a list of all the
values in Column A which have an quot;xquot; next to them in Column B. How can
I do this?

View the following in fixed-with font.

For example, if this is my first table:

A B C
thing 1/28/2006 1/29/2006
rock x
scissors x
frog x x
flipper
grumpy x
doctor x
notebook x
power x x

I want my second table to look like:

A B
1/28/2006 1/29/2006
rock scissors
frog frog
doctor grumpy
power notebook
power

And so on, for each day.

And for mondo extra bonus points, propose a way to do this in reverse.
That is, to put an quot;xquot; under the appropriate date column in the same
row (in table 1) as the things listed in table 2.

Much thanks-
Peter KellerHi!

Take a look at this sample file:

s49.yousendit.com/d.aspx?id=1...G0CI0F8LTOMUXP

gt; And for mondo extra bonus points, propose a way to do this in reverse.
gt; That is, to put an quot;xquot; under the appropriate date column in the same
gt; row (in table 1) as the things listed in table 2.

You can do this to create *ANOTHER* table 1 but not the original table 1.

Biff

quot;pakquot; gt; wrote in message oups.com...
gt; Column A contains a list of strings, under the heading quot;thingquot;. Next
gt; to each string, Column B contains blanks or an quot;xquot;, with a date as a
gt; heading. In another worksheet, I want to create a list of all the
gt; values in Column A which have an quot;xquot; next to them in Column B. How can
gt; I do this?
gt;
gt; View the following in fixed-with font.
gt;
gt; For example, if this is my first table:
gt;
gt; A B C
gt; thing 1/28/2006 1/29/2006
gt; rock x
gt; scissors x
gt; frog x x
gt; flipper
gt; grumpy x
gt; doctor x
gt; notebook x
gt; power x x
gt;
gt; I want my second table to look like:
gt;
gt; A B
gt; 1/28/2006 1/29/2006
gt; rock scissors
gt; frog frog
gt; doctor grumpy
gt; power notebook
gt; power
gt;
gt; And so on, for each day.
gt;
gt; And for mondo extra bonus points, propose a way to do this in reverse.
gt; That is, to put an quot;xquot; under the appropriate date column in the same
gt; row (in table 1) as the things listed in table 2.
gt;
gt; Much thanks-
gt; Peter Keller
gt;
Or you can use Advanced Filter for the second table.
Check: Copy to another location
Database= header thing
Criteria= blank header =OFFSET(thing,,n)=quot;xquot; for n={1,2}
Then replace result headers with dates.