Posted to microsoft.public.excel.misc

Rao Ratan Singh Rao Ratan Singh is offline

external usenet poster

Posts: 107

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
want to copy formula, only change one number in formula	cac1966	Excel Worksheet Functions	3	March 12th 07 10:39 PM
Change Formula	fak119	Excel Discussion (Misc queries)	2	July 28th 06 10:49 AM
How does Data Validation change with a formula change?	MayClarkOriginals	Excel Worksheet Functions	3	July 5th 06 04:50 AM
how do I change "fx" in formula bar to "="	rip	Setting up and Configuration of Excel	1	September 1st 05 09:05 PM
Cannot change a formula	Richard F	Excel Discussion (Misc queries)	1	January 18th 05 01:57 AM

All times are GMT +1. The time now is 05:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us