Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering a Text Column based on a particular word
I have a worksheet with one "Remarks" Column. The "Remarks" column
fields may have the following text may be awarded on manpower rates can be awarded on general quotation Ref No. XXX may be awarded on previous order basis may be awarded via General quotation Ref No. YYY has carried out the job on basis of general quotation Ref No. ABAB may be awarded on approved rates .... and so on and so forth I would like to filter this column based on the text which has the word "general" in it. As it can be observed, the word "general" does not have a fixed location in the column and then again sometimes the 'g' of general may be in the upper case too. Thanks for the help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering a Text Column based on a particular word
Data Filter AutoFilter Custom Contains
-- Gary''s Student - gsnu200842 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
filtering excel worksheet column by color of text | Excel Worksheet Functions | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) |