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
|