| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
referencing cells based on conditions in other cells
i need a function that takes cash values associated with dates and populates
a table based on fiscal quarters. ie. Company A Dec 23, 2008 250000 Company B January 2, 2008 450000 .... Q1 Q2 Q3 Q4 Company A 250000 Company B 450000 etc. however, there are multiple years to deal with and the fiscal years in question begin in march. i.e. Q1 is March 1-June 1. any help would be most appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cells based on conditions to another workbook | Excel Discussion (Misc queries) | |||
| Copy cells based on conditions to another workbook | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) | |||
| Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
Threaded Mode
