View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rao Ratan Singh Rao Ratan Singh is offline
external usenet poster
 
Posts: 107
Default 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