Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel: select the last 20 rows of data in a column
How do I create a formula that will select the last 20 entries in a column of
a database? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel: select the last 20 rows of data in a column
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) "Tad Blanchard" <Tad wrote in message ... How do I create a formula that will select the last 20 entries in a column of a database? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel: select the last 20 rows of data in a column
Yeah, 5 functions for 3. Can't see much rationale in that.
-- HTH RP (remove nothere from the email address if mailing direct) "Krishnakumar" wrote in message news:Krishnakumar.1z1fxa_1132897802.7817@excelforu m-nospam.com... You can avoid the Volatile OFFSET function. Try, =SUM(INDEX(A:A,COUNTA(A:A)-19):INDEX(A:A,COUNTA(A:A))) HTH -- Krishnakumar ------------------------------------------------------------------------ Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138 View this thread: http://www.excelforum.com/showthread...hreadid=487782 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
Select Rows dependant on certain field data | New Users to Excel | |||
Excel charts should let me select a range for data labels. | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |