Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please
I have created a spreadsheet to track sports schedules and stats.
On one sheet I have a column of cells that using the Countif function I track wins and losses. I would like to have a formula, function, macro or something that will automatically update say the last 10 entries in the column. Is there such a thing? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please
Is there such a thing?
Probably, but you need to explain what you want to do with the values in the last 10 cells. for example this sums the last 10 non-zero cells in A1 - a1000 =SUM(INDEX(A1:A1000,LARGE(ROW(A1:A1000)*(A1:A1000< 0),10)):A1000) This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "jfe4245" wrote: I have created a spreadsheet to track sports schedules and stats. On one sheet I have a column of cells that using the Countif function I track wins and losses. I would like to have a formula, function, macro or something that will automatically update say the last 10 entries in the column. Is there such a thing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|