is date can be filtered to a different cell?-subtotal or any other function?

Hi folks,
Just wondering if date (once filtered) can be populate in another cell using
subtotal or any other function?
Thanks
Morphyus


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1

You can use the Subtotal function to return data from the visible cells in a
filtered list. For example, to return the latest date in column A:

=SUBTOTAL(4,A:A)
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"Morphyus C via OfficeKB.com" wrote:

> Hi folks,
> Just wondering if date (once filtered) can be populate in another cell using
> subtotal or any other function?
> Thanks
> Morphyus
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200508/1
>

Debra Thanks so much.

Debra Dalgleish wrote:
>You can use the Subtotal function to return data from the visible cells in a
>filtered list. For example, to return the latest date in column A:
>
> =SUBTOTAL(4,A:A)
>> Hi folks,
>> Just wondering if date (once filtered) can be populate in another cell using
>> subtotal or any other function?
>> Thanks
>> Morphyus


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1