| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to autofill a consecutive cells in a column?
This problem has bugged me for a long time. Please help!
I have column A with 2, 4, 6, 8, ....100, which represents the time line in days. Column B with 0, 0, 1, 0, 3, 2, ...5, 3... which represents a certain event that happend in that day. Let's say totally the event happened 300 times in the 100 days. I would like to have a column C, which has 300 cells corresponding to those 300 events. If the first event happened once in day 6, then put a "6" into first cell of column C. If the next event happened 3 times in day 10, then put 10, 10 ,10, into 2nd, 3rd, 4th cell of column C. So finally I have 300 cells in column C, each cell representing the day on which the corresponding event happened. I really wish I made it clear. Please help! :D |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to autofill a consecutive cells in a column?
Diablo,
Please don't multi-post your questions. See my reply in worksheetfunctions... do you want a worksheet function solution, or a macro solution? HTH, Bernie MS Excel MVP "diablo9" wrote in message ... This problem has bugged me for a long time. Please help! I have column A with 2, 4, 6, 8, ....100, which represents the time line in days. Column B with 0, 0, 1, 0, 3, 2, ...5, 3... which represents a certain event that happend in that day. Let's say totally the event happened 300 times in the 100 days. I would like to have a column C, which has 300 cells corresponding to those 300 events. If the first event happened once in day 6, then put a "6" into first cell of column C. If the next event happened 3 times in day 10, then put 10, 10 ,10, into 2nd, 3rd, 4th cell of column C. So finally I have 300 cells in column C, each cell representing the day on which the corresponding event happened. I really wish I made it clear. Please help! :D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to autofill a consecutive cells in a column? | Excel Worksheet Functions | |||
| how to autofill a consecutive cells in a column? | Excel Discussion (Misc queries) | |||
| count text in non consecutive cells in column | Excel Discussion (Misc queries) | |||
| How to drag and autofill a non consecutive range of cells? | Excel Discussion (Misc queries) | |||
| Need to find two consecutive identical cells (in a column). | Excel Programming | |||
Linear Mode
