G
Guest
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?
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?