All,
Looked hard and long, but cannot find the answer, so turning again to you experts!!!
I have a long column of real dates, (dd/mm/yy) in column D from d18 downwards.
I then have various filters, which obviously changes what dates are shown......big question...how can I show what is the earliest and newest dates from whatever is outputted from my filtering?!
Thanks for looking.
Skyping
Last edited by skyping; 03-04-2015 at 05:35 PM.
Found it!!!!
DESCRIPTION
The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a list or database.
SYNTAX
The syntax for the Microsoft Excel SUBTOTAL function is:
SUBTOTAL( method, range1, [range2, ... range_n] )
Parameters or Arguments
method is type of subtotal to create, but be careful which method you select. method can be a value ranging from 1 - 11 that includes hidden values or a value ranging from 101 - 111 that ignores hidden values in the calculation.
method can be a value ranging from 1 - 11 as follows: (which includes hidden values in the calculation)
Value Explanation
(includes hidden values)
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
e.g. earliest date = =SUBTOTAL(5,d18:d2009)
latest = =SUBTOTAL(4,d18:d2009)
SOLVED!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks