Sorting text strings

Q

QC-Dude

I have a spreadsheet. which is several columns of cells populated with text
strings.
These text strings are quality system requirement clauses {examples 'Thou
shalt calibrate your instruments', 'Thou shalt train new employees', etc},
taken from various quality standards [ISO 9001, FDA, nuclear regs, aerospace
standards, etc].
Each cell is a single requirement clause/sentence. Each column is all of
the clauses under one quality standard as above.

What I need to do is sort the requirements, so that the user can select a
topic [i.e. 'calibration'] from a pulldown list, and the calibration
requirements across many different standards 'columns' will display as in a
report format on a separate worksheet.

For a given column, several cells may fall under one 'topic' [i.e.
'calibration']. Furthermore, any single cell may may into more than one
'topic' [cell example: 'Training progress shall be discussed during mgmt
review meeting' -this would fall under 2 topics: 'training' and 'management
review'].

I seek the community's advice on how to approach this. There's probably
several ways to achieve this. I need to learn how to tag/label individual
cells with 1 or more 'topics'. I am most grateful for everyone's good ideas
& technical advice here.
 
G

Gary''s Student

You should definitely consider using a special form of AutoFilter:

Data > Filter > AutoFilter > Custom > Contains and you your criteria
 

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

Top