LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default filter multiple values

I have a worksheet with the following details

Object Name Last Database Backup

NZ01_root 24/10/09 01:11:02
NZ01_netezza_data 24/10/09 05:43:14
AIX353_livebe_RMAN 24/10/09 01:06:05
AIX353_livech_RMAN 23/10/09 23:39:04

Now can i kind of create a code or template that would like have a fixed
list which has to be searched within the worksheet? For e.g in the above
example, say i have a report which publishes hundreds of object names, how do
i get the date and times of "Z01_root" and "NZ01_netezza_data" only, the
rest should be filtered out. i am talking about just keeping like 100 object
names out of a list of 500 object names. Note: there is no order, row/coloumn
for the initial report which has all the details.






 
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
Filter for unique values in multiple columns sahafi Excel Discussion (Misc queries) 6 October 24th 08 09:05 PM
Advanced Filter for Values in Column M greater than Values in Colu SteveC Excel Discussion (Misc queries) 3 May 2nd 06 07:55 PM
Filter: Multiple values in a cell pandora Excel Discussion (Misc queries) 1 December 6th 05 07:03 AM
How do I Auto-Filter with multiple values in a cell in Excel? Burghthing Excel Discussion (Misc queries) 2 November 23rd 05 04:41 PM
Pivot table page filter not accepting multiple values. Workaround? jco Excel Worksheet Functions 2 September 25th 05 09:35 PM


All times are GMT +1. The time now is 04:38 AM.

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

About Us

"It's about Microsoft Excel"