|
is date can be filtered to a different cell?
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 |
| All times are GMT +1. The time now is 10:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com