| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a YTD table which compares production for 4 facil.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a YTD table which compares production for 4 facil.
Maybe something like the csv file below would be useful.
---------------- cut here ------------- ,A,B,C,D,A YTD,B YTD,C YTD,D YTD Jan,,,,,=B2,=C2,=D2,=E2 Feb,,,,,=F2+B3,=G2+C3,=H2+D3,=I2+E3 Mar,,,,,=F3+B4,=G3+C4,=H3+D4,=I3+E4 Apr,,,,,=F4+B5,=G4+C5,=H4+D5,=I4+E5 May,,,,,=F5+B6,=G5+C6,=H5+D6,=I5+E6 Jun,,,,,=F6+B7,=G6+C7,=H6+D7,=I6+E7 Jul,,,,,=F7+B8,=G7+C8,=H7+D8,=I7+E8 Aug,,,,,=F8+B9,=G8+C9,=H8+D9,=I8+E9 Sep,,,,,=F9+B10,=G9+C10,=H9+D10,=I9+E10 Oct,,,,,=F10+B11,=G10+C11,=H10+D11,=I10+E11 Nov,,,,,=F11+B12,=G11+C12,=H11+D12,=I11+E12 Dec,,,,,=F12+B13,=G12+C13,=H12+D13,=I12+E13 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a production v's target report in excel including graphs | Excel Discussion (Misc queries) | |||
| IF statement (non nested) that compares cell value against range | Excel Worksheet Functions | |||
| Function that compares dates | Excel Worksheet Functions | |||
| formula that compares different ranges | Excel Worksheet Functions | |||
| How to create a macro that compares a list to another list | New Users to Excel | |||
Linear Mode
