| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
| Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
