| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running Sum across columns but only to a certain point
If you change the layout of your spreadsheet so that only two columns
contain the data, where Column A contains the date, and Column B contains the corresponding values, you could use the following formula instead... =IF(N(H2),INDEX(A2:A21,MATCH(TRUE,SUBTOTAL(9,OFFSE T(B2:B21,,,ROW(B2:B21)- ROW(B2)+1))=H2,0)),"") ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , Steven Cheng wrote: Thanks Domenic....looks like a complicated formula....maybe I should have just created a function for this instead... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with grouping columns | New Users to Excel | |||
| Clearing information in certain columns | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
