| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom lists and custom formulas?
i have a custom list of four quarters (Q1, Q2, Q3, Q4). I'd like to
have a formula in a cell that is able to calculate previous quarters in the list. For example: Q2 - 1 = Q1; Q4 - 2 = Q2. I'd also like to be able to use years with the quarters. For example: Q2 2006 - 3 = Q3 2005. Is this possible? When i do that, i just get a #value error and i cant find a solution! thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In the Options window how to create new custom lists | Excel Discussion (Misc queries) | |||
| Storing custom lists | Excel Discussion (Misc queries) | |||
| Custom Lists in Excel | Excel Discussion (Misc queries) | |||
| Using/referencing custom lists | Excel Worksheet Functions | |||
| Custom Lists | Excel Discussion (Misc queries) | |||
Linear Mode
