I've got a spreadsheet with questions that relate to use cases. I've a
column named "Use Case". Each row in the table has unique questions and
answers pertaining to each use case. Some use cases have 50 entries, others
only 3 or 4. When I filter the use case column, Excel composes a list of all
use cases (with each unique use case occurring only once in the filter list).
How can I create that SAME list in a separate column of the worksheet or in
a separate worksheet?
--
Jim

You can use Advanced Filter. Insert a new worksheet, then copy the
data (including heading) from your current sheet to the new sheet.
With the data still highlighted, click on Data | Sort and sort the
data. With it still highlighted, click on Data | Filter | Advanced
Filter. In the pop-up you want to click Unique Records Only and Copy
to another location - specify C1 in the box. Click OK and you will
have your unique list. Delete columns A and B.

Hope this helps.

Pete

On Oct 15, 6:01 pm, Jim wrote:
I've got a spreadsheet with questions that relate to use cases. I've a
column named "Use Case". Each row in the table has unique questions and
answers pertaining to each use case. Some use cases have 50 entries, others
only 3 or 4. When I filter the use case column, Excel composes a list of all
use cases (with each unique use case occurring only once in the filter list).
How can I create that SAME list in a separate column of the worksheet or in
a separate worksheet?
--
Jim