Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter for unique values in multiple columns | Excel Discussion (Misc queries) | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
Filter: Multiple values in a cell | Excel Discussion (Misc queries) | |||
How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions |