How do I create a formula that will select the last 20 entries in a column of a database?
T Tad Blanchard Nov 23, 2005 #1 How do I create a formula that will select the last 20 entries in a column of a database?
B Bob Phillips Nov 23, 2005 #2 This is the sort of thing OFFSET($A$1,COUNTA(A:A)-20,0,20,1) which can be used like so =SUM(OFFSET($A$1,COUNTA(A:A)-20,0,20,1)) -- HTH RP (remove nothere from the email address if mailing direct)
This is the sort of thing OFFSET($A$1,COUNTA(A:A)-20,0,20,1) which can be used like so =SUM(OFFSET($A$1,COUNTA(A:A)-20,0,20,1)) -- HTH RP (remove nothere from the email address if mailing direct)
K Krishnakumar Nov 25, 2005 #3 You can avoid the Volatile OFFSET function. Try, =SUM(INDEX(A:A,COUNTA(A:A)-19):INDEX(A:A,COUNTA(A:A))) HTH
You can avoid the Volatile OFFSET function. Try, =SUM(INDEX(A:A,COUNTA(A:A)-19):INDEX(A:A,COUNTA(A:A))) HTH
B Bob Phillips Nov 25, 2005 #4 Yeah, 5 functions for 3. Can't see much rationale in that. -- HTH RP (remove nothere from the email address if mailing direct) "Krishnakumar" <[email protected]> wrote in message news:[email protected]...
Yeah, 5 functions for 3. Can't see much rationale in that. -- HTH RP (remove nothere from the email address if mailing direct) "Krishnakumar" <[email protected]> wrote in message news:[email protected]...
