Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
appending worksheet records into 1 worksheet JASelep Excel Worksheet Functions 0 September 4th 07 02:44 PM
Validation - Narrowing down choices Jamie Excel Discussion (Misc queries) 4 April 9th 07 07:08 AM
remove blank records (row) in worksheet sahusir Excel Discussion (Misc queries) 2 October 14th 06 05:12 PM
how to group records in a new worksheet Gunther Excel Worksheet Functions 1 March 1st 06 10:37 AM
how to group records in a new worksheet Gunther Excel Discussion (Misc queries) 1 February 22nd 06 06:59 AM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"