Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on sorting text strings
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. -- Warm Regards, MikCra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Text Strings | Excel Worksheet Functions | |||
Parseing Text strings | Excel Discussion (Misc queries) | |||
Separating Text strings. | Excel Discussion (Misc queries) | |||
Text Strings Conversion | Excel Worksheet Functions | |||
Combining text strings | Excel Worksheet Functions |