Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
narrowing down records in another worksheet
While using data extracted from Remedy Management Software - need to filter
the information to specific areas of concern. Below is the header line and one record for example. Case ID+ Create Date Resolved Time Status* Category* Type* Item* Group+ Individual+ Summary* Work Log(240000008) HD0000000321385 3/10/2009 10:39 3/31/2009 9:46 Resolved LAN Other Other DC OSS Any Person User reports their Wireless keyboard is not working. 3/10/2009 10:48:08 AM jermaine.myers The customer contacted the Help Desk via: Phone The customer was notified that their problem was being addressed: No The problem could be duplicated: NA The full problem description is: User reports their Wireless keyboard is not working. User has changed the Batteriers. 3/27/2009 11:02:48 AM bruce.bates1 e-mail sent: but got out of Office Reply -----Original Message----- From: Bates, Bruce Mr NGDC Sent: Friday, March 27, 2009 11:02 AM To: Williamson, Octavia SSG NGDC Subject: Ticket 321385 (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Does this still remain an issue: User reports their Wireless keyboard is not working. Classification: UNCLASSIFIED Caveats: NONE 3/27/2009 1:00:22 PM patrick.scott2 Called user, vm says no one will be in until April 6th. 3/31/2009 9:46:16 AM patrick.scott2 Closing out ticket, user will not be in until April 6th. Will ask user to resubmit ticket upon there arrival. Summary* and Work Log(240000008) columns cotain more detailed notes of the situation and is the focus of this concern. Is there a way to run multiple filters on these two columns where each keyword filters the selections further? For instance, if the keyword "internet" was used to perform the first filter, then "java" for the second, and then "78593" in order to find information that may not be located in any particular order but contained somewhere within the text? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
appending worksheet records into 1 worksheet | Excel Worksheet Functions | |||
Validation - Narrowing down choices | Excel Discussion (Misc queries) | |||
remove blank records (row) in worksheet | Excel Discussion (Misc queries) | |||
how to group records in a new worksheet | Excel Worksheet Functions | |||
how to group records in a new worksheet | Excel Discussion (Misc queries) |