Tex Formula Does not change.

[Guest]

Hi all,
I m using this formula ="From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to
"&TEXT(MAX(A6:A2151),"dd.mm.yy") for Data entered from a Date to last date.
But when I autofilter by Date this formula does not change according to Date.

How i should modify this formula so it can be change according to filtered
range.

Regards

RRS

 

[Bob Phillips]

Change column A to a custom format (Cells>Format>Custom) of "From "
dd.mm.yy, including the quotes, and filter column A

--
HTH

Bob

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

 

[Guest]

Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?

 

[Fred Smith]

It's not a formula, it's a format. And yes, he means enter it as a custom
format.

 

[Guest]

Hi Smit,
Probably my question was understood wrongly. My this Formula/format "From
"&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy") is in
cell E1 and Date Range is in A Column from A6.

Whe I use Custom AutoFilter to Date Column. This A6 Formula Should change
according to Filter.

Assume that I filter for the Month of March Month.

CustomAutoFilter>IsGreaterThan>And>IsLessThan This Formula should display

"From 01.03.07 to 31.03.07

So please tell me what is necessary changes should I do in this
formula/format.

Regards

Rao Ratan Singh

 

[Fred Smith]

You're right, we misunderstood your requirements.

The formula doesn't change because it's still looking at the entire range
(A6:A2151). Filtering doesn't change a formula, it only chooses rows to display.

However, you can switch to the Subtotal function, because it will recognize on a
filtered group.

"From "&TEXT(Subtotal(4,A6:A2151),"dd.mm.yy")&" to
"&TEXT(Subtotal(4,A6:A2151),"dd.mm.yy")

should do what you want.

 

[Guest]

Sir,
It is not working. It is returning "From 05.04.07 to 05.04.07" in autofilter
position and without filter position.

Hope u will send me another solution.

Regards

RRS

 

[Guest]

Sir,
It is not working. It is returning "From 05.04.07 to 05.04.07" in autofilter
position and without filter position.

Hope u will send me another solution.