| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
| cell assumes wrong date | Setting up and Configuration of Excel | |||
Linear Mode
