I have associated several names with a group number in one spreadsheet (i.e.
one column has the name, the next column has the group number). I want to
move those names to a different spreadsheet and associate those names to a
specific column. Formula might be something like "if group number equals "1"
in spreadsheet X, list it in column Y in spreadsheet Z. Can anyone help?



A simple way to formulas model it up dynamically ....
Assume your source data in sheet: x, cols A and B, data from row2 down,
where col A = names, col B = group numbers assigned
In sheet: z
Let's say the group number will be input in Y1, eg: 1
Put in X2:
Put in Y2:
Copy X2:Y2 down to cover the max expected extent of source data. Hide away
col X. The required list of names for the group num input in Y1 ie: 1, will
appear neatly packed at the top. Change the input in Y1 to say: 2, and you'd
get all the names for group num 2. voila? celebrato, hit the YES below

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question