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.

Sunir,

I'm not sure what you want, but you can always use a column of helper cells that return TRUE or
FALSE depending on a criteria, if you criteria is very complex and cannot be solved using one of the
custom filters available.

Let's say that you have a list of names that you want to show - use a formula like this

=NOT(ISERROR(MATCH(NameValue,NameList,False)))

Like

=NOT(ISERROR(MATCH(A2,$H2:$H100,False)))

and copy down, then filter on that column of formulas.

HTH,
Bernie
MS Excel MVP


"Sunir M S" <Sunir M wrote in message
...
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.

Thanks a lot Bernie.

Howeevr considering my lack of experience with excel i couldnt get that
right..Let me be more simple this time.

NAME AGE SEX
Andre 25 m
Charles 26 m
Julia 22 f
dev 25 m

Now lez say this list continue to a few hunfred names and it gets published
every day. One more condition is that the name do not come in the same order
i.e andre specific to row #2 etc. they may be random.

Now i need to to search for julia and dev within this sheet only, i.e filter
out details of julia and dev only, the rest should be filtered out.

Hope i made some sense. Apologies for the ignorance. I am an engineer and i
din have the need to work on the wonderful tool called excel till now. Thanks
a lot in advance!!


"Bernie Deitrick" wrote:

Sunir,

I'm not sure what you want, but you can always use a column of helper cells that return TRUE or
FALSE depending on a criteria, if you criteria is very complex and cannot be solved using one of the
custom filters available.

Let's say that you have a list of names that you want to show - use a formula like this

=NOT(ISERROR(MATCH(NameValue,NameList,False)))

Like

=NOT(ISERROR(MATCH(A2,$H2:$H100,False)))

and copy down, then filter on that column of formulas.

HTH,
Bernie
MS Excel MVP


"Sunir M S" <Sunir M wrote in message
...
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.








.

AutofilterCustom

Equals Julia OR equals dev


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 03:00:01 -0800, Sunir M S
wrote:

Thanks a lot Bernie.

Howeevr considering my lack of experience with excel i couldnt get that
right..Let me be more simple this time.

NAME AGE SEX
Andre 25 m
Charles 26 m
Julia 22 f
dev 25 m

Now lez say this list continue to a few hunfred names and it gets published
every day. One more condition is that the name do not come in the same order
i.e andre specific to row #2 etc. they may be random.

Now i need to to search for julia and dev within this sheet only, i.e filter
out details of julia and dev only, the rest should be filtered out.

Hope i made some sense. Apologies for the ignorance. I am an engineer and i
din have the need to work on the wonderful tool called excel till now. Thanks
a lot in advance!!


"Bernie Deitrick" wrote:

Sunir,

I'm not sure what you want, but you can always use a column of helper cells that return TRUE or
FALSE depending on a criteria, if you criteria is very complex and cannot be solved using one of the
custom filters available.

Let's say that you have a list of names that you want to show - use a formula like this

=NOT(ISERROR(MATCH(NameValue,NameList,False)))

Like

=NOT(ISERROR(MATCH(A2,$H2:$H100,False)))

and copy down, then filter on that column of formulas.

HTH,
Bernie
MS Excel MVP


"Sunir M S" <Sunir M wrote in message
...
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.








.

But like i said i just piut in an example for 2 names to show up. I am
talking about 1000 total names and filtering out some 400 names. That is i
need to filter about 600 names. cutom filter gives me just 2 entities that
can be filtered

Thanks in advance

Sunir M S

"Gord Dibben" wrote:

AutofilterCustom

Equals Julia OR equals dev


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 03:00:01 -0800, Sunir M S
wrote:

Thanks a lot Bernie.

Howeevr considering my lack of experience with excel i couldnt get that
right..Let me be more simple this time.

NAME AGE SEX
Andre 25 m
Charles 26 m
Julia 22 f
dev 25 m

Now lez say this list continue to a few hunfred names and it gets published
every day. One more condition is that the name do not come in the same order
i.e andre specific to row #2 etc. they may be random.

Now i need to to search for julia and dev within this sheet only, i.e filter
out details of julia and dev only, the rest should be filtered out.

Hope i made some sense. Apologies for the ignorance. I am an engineer and i
din have the need to work on the wonderful tool called excel till now. Thanks
a lot in advance!!


"Bernie Deitrick" wrote:

Sunir,

I'm not sure what you want, but you can always use a column of helper cells that return TRUE or
FALSE depending on a criteria, if you criteria is very complex and cannot be solved using one of the
custom filters available.

Let's say that you have a list of names that you want to show - use a formula like this

=NOT(ISERROR(MATCH(NameValue,NameList,False)))

Like

=NOT(ISERROR(MATCH(A2,$H2:$H100,False)))

and copy down, then filter on that column of formulas.

HTH,
Bernie
MS Excel MVP


"Sunir M S" <Sunir M wrote in message
...
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.








.


.

Sunir,

What is the logic you use to decide whether to show a name or not?

Create a formula using that logic for each row, and make sure that it
returns TRUE or FALSE. Then filter on that column.

HTH,
Bernie
MS Excel MVP


"Sunir M S" wrote in message
...
But like i said i just piut in an example for 2 names to show up. I am
talking about 1000 total names and filtering out some 400 names. That is
i
need to filter about 600 names. cutom filter gives me just 2 entities that
can be filtered

Thanks in advance

Sunir M S

"Gord Dibben" wrote:

AutofilterCustom

Equals Julia OR equals dev


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 03:00:01 -0800, Sunir M S
wrote:

Thanks a lot Bernie.

Howeevr considering my lack of experience with excel i couldnt get that
right..Let me be more simple this time.

NAME AGE SEX
Andre 25 m
Charles 26 m
Julia 22 f
dev 25 m

Now lez say this list continue to a few hunfred names and it gets
published
every day. One more condition is that the name do not come in the same
order
i.e andre specific to row #2 etc. they may be random.

Now i need to to search for julia and dev within this sheet only, i.e
filter
out details of julia and dev only, the rest should be filtered out.

Hope i made some sense. Apologies for the ignorance. I am an engineer
and i
din have the need to work on the wonderful tool called excel till now.
Thanks
a lot in advance!!


"Bernie Deitrick" wrote:

Sunir,

I'm not sure what you want, but you can always use a column of helper
cells that return TRUE or
FALSE depending on a criteria, if you criteria is very complex and
cannot be solved using one of the
custom filters available.

Let's say that you have a list of names that you want to show - use a
formula like this

=NOT(ISERROR(MATCH(NameValue,NameList,False)))

Like

=NOT(ISERROR(MATCH(A2,$H2:$H100,False)))

and copy down, then filter on that column of formulas.

HTH,
Bernie
MS Excel MVP


"Sunir M S" <Sunir M wrote in message
...
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.








.


.