is date can be filtered to a different cell?

[Morphyus C via OfficeKB.com]

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

 

[Debra Dalgleish]

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)

 

[Morphyus C via OfficeKB.com]

Debra Thanks so much.

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)