Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Here is one for you guys: I have the following data electricity meter readings registered which I want to split between pre-defined periods: Data available: 15-Jan-06 78 days 30-Dec-05 300 days 14-Oct-05 200 days 30-Nov-05 45 days Data required: I need to split these readings into brackets and obtain the following answers: Jan-06 Dec-05 Nov-05 Oct-05 Reading 1 15 days 31 days 30 days 2 days etc etc Any ideas....?? Thanks in advance Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
30, 60, 90 days late and due within 14 days | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions |