| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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!  |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:6D181DB8-6609-415B-8E16-(E-Mail Removed)... > 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! |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Paste changing cell contents to consecutive cells in a column | =?Utf-8?B?bWVnZ3k=?= | Microsoft Excel Worksheet Functions | 3 | 4th Sep 2007 09:21 PM |
| how to autofill a consecutive cells in a column? | =?Utf-8?B?ZGlhYmxvOQ==?= | Microsoft Excel Worksheet Functions | 3 | 25th Apr 2007 12:02 AM |
| how to autofill a consecutive cells in a column? | =?Utf-8?B?ZGlhYmxvOQ==?= | Microsoft Excel Misc | 1 | 24th Apr 2007 09:47 PM |
| How to drag and autofill a non consecutive range of cells? | =?Utf-8?B?UEg=?= | Microsoft Excel Misc | 1 | 9th Mar 2006 07:48 PM |
| Need to find two consecutive identical cells (in a column). | =?Utf-8?B?SG93IGRpZCBJIGdldCBoZXJlPw==?= | Microsoft Excel Programming | 10 | 3rd Feb 2006 07:12 PM |
