| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed.
My first sheet (called Data) contains following information:
Col A Col B Col C Col D Part 1 5 Date =weeknum(C1) i.e. 46 Part 2 6 Date 46 Part 1 4 Date 46 Part 1 5 Date 47 This list is filled with more rows with the same week number. On another sheet (called Summary) I try to summarize the data like following: Col A Col B Col C Col D 46 47 Formula Formula I need a formula for this row, which automatically fills in the next week number if it shows up in my database (only column per week). I.e. as soon as in column D of the Data sheet the next week number shows up (here 48) it is automatically shown in Col C of my summary sheet etc. Who can help me with this formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| continuous sum formula needed | Excel Discussion (Misc queries) | |||
| Formula Help Needed | Excel Discussion (Misc queries) | |||
| More Help Needed with Count formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Help! Formula needed. | Excel Discussion (Misc queries) | |||
Threaded Mode
