Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to list numbers
I have a column of numbers say 1 to 10 in column A In column B at various rows there could be a number. This is the number of times I need the number in column A repeated in column C eg. A B C 1 3 2 3 3 3 3 4 2 4 5 2 4 6 1 5 7 5 8 6 9 10 10 1 I have been trying to write a macro for this. I have got as far as going down column A and identifying how many rows are populated and then got stuck. Help would be appreciated -- tryer ------------------------------------------------------------------------ tryer's Profile: http://www.excelforum.com/member.php...o&userid=16546 View this thread: http://www.excelforum.com/showthread...hreadid=397591 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I extract a list of numbers missing in a list? | New Users to Excel | |||
how can I add +ve numbers only in a list of +ve and -ve numbers | Excel Discussion (Misc queries) | |||
change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
How to create a macro that compares a list to another list | New Users to Excel |