Tex Formula Does not change.
 

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

Tex Formula Does not change.
 

Change column A to a custom format (CellsFormatCustom) 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)

"Rao Ratan Singh" wrote in message
...
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

Tex Formula Does not change.
 

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



"Bob Phillips" wrote:

Change column A to a custom format (CellsFormatCustom) 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)

"Rao Ratan Singh" wrote in message
...
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

Tex Formula Does not change.
 

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

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

Change column A to a custom format (CellsFormatCustom) 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)

"Rao Ratan Singh" wrote in message
...
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

Tex Formula Does not change.
 

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.
CustomAutoFilterIsGreaterThanAndIsLessThan 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" wrote:

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

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

Change column A to a custom format (CellsFormatCustom) 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)

"Rao Ratan Singh" wrote in message
...
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

Tex Formula Does not change.
 

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.
--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
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.
CustomAutoFilterIsGreaterThanAndIsLessThan 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" wrote:

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

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

Change column A to a custom format (CellsFormatCustom) 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)

"Rao Ratan Singh" wrote in
message
...
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

Tex Formula Does not change.
 

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

"Fred Smith" wrote:

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.
--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
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.
CustomAutoFilterIsGreaterThanAndIsLessThan 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" wrote:

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

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

Change column A to a custom format (CellsFormatCustom) 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)

"Rao Ratan Singh" wrote in
message
...
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

Tex Formula Does not change.
 

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.