Need Text formula Help
 

I m using this formula/format to displya Date Range what i select by autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i filter
by drop down list by selecting any date this not work properly. what should
make change in this.

Need Text formula Help
 

What do you mean by did not work properly?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rao Ratan Singh" wrote in message
...
I m using this formula/format to displya Date Range what i select by
autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to
"&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i
filter
by drop down list by selecting any date this not work properly. what
should
make change in this.

Need Text formula Help
 

When you apply data|Filter|autofilter, you can use =subtotal(5,...) to get the
minimum and =subtotal(4,...) to get the max.

=Min() and =max() will not ignore those hidden rows.

so:
="From "&TEXT(subtotal(5,A6:A2151),"dd.mm.yy")
&" to "&TEXT(subtotal(4,A6:A2151),"dd.mm.yy")

May work for you

Rao Ratan Singh wrote:

I m using this formula/format to displya Date Range what i select by autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i filter
by drop down list by selecting any date this not work properly. what should
make change in this.

--

Dave Peterson

Need Text formula Help
 

Thank you dave. But How i can cutom ato filter between two date e.g. 01.04.07
to 30.04.07 (dd.mm.yy). I m using office XP.



"Dave Peterson" wrote:

When you apply data|Filter|autofilter, you can use =subtotal(5,...) to get the
minimum and =subtotal(4,...) to get the max.

=Min() and =max() will not ignore those hidden rows.

so:
="From "&TEXT(subtotal(5,A6:A2151),"dd.mm.yy")
&" to "&TEXT(subtotal(4,A6:A2151),"dd.mm.yy")

May work for you

Rao Ratan Singh wrote:

I m using this formula/format to displya Date Range what i select by autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i filter
by drop down list by selecting any date this not work properly. what should
make change in this.

--

Dave Peterson

Need Text formula Help
 

You put those values in the filter criteria using the custom option.
Remember to format those dates as you see them in the list.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rao Ratan Singh" wrote in message
...
Thank you dave. But How i can cutom ato filter between two date e.g.
01.04.07
to 30.04.07 (dd.mm.yy). I m using office XP.



"Dave Peterson" wrote:

When you apply data|Filter|autofilter, you can use =subtotal(5,...) to
get the
minimum and =subtotal(4,...) to get the max.

=Min() and =max() will not ignore those hidden rows.

so:
="From "&TEXT(subtotal(5,A6:A2151),"dd.mm.yy")
&" to "&TEXT(subtotal(4,A6:A2151),"dd.mm.yy")

May work for you

Rao Ratan Singh wrote:

I m using this formula/format to displya Date Range what i select by
autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to
"&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i
filter
by drop down list by selecting any date this not work properly. what
should
make change in this.

--

Dave Peterson

Need Text formula Help
 

Thank you bob, thank you very much for your help.

"Bob Phillips" wrote:

You put those values in the filter criteria using the custom option.
Remember to format those dates as you see them in the list.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rao Ratan Singh" wrote in message
...
Thank you dave. But How i can cutom ato filter between two date e.g.
01.04.07
to 30.04.07 (dd.mm.yy). I m using office XP.



"Dave Peterson" wrote:

When you apply data|Filter|autofilter, you can use =subtotal(5,...) to
get the
minimum and =subtotal(4,...) to get the max.

=Min() and =max() will not ignore those hidden rows.

so:
="From "&TEXT(subtotal(5,A6:A2151),"dd.mm.yy")
&" to "&TEXT(subtotal(4,A6:A2151),"dd.mm.yy")

May work for you

Rao Ratan Singh wrote:

I m using this formula/format to displya Date Range what i select by
autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to
"&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i
filter
by drop down list by selecting any date this not work properly. what
should
make change in this.

--

Dave Peterson