Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Loop to Count Copy
I have two columns of data- I would like to count the number of
entries in col B based on col A, put the cell value for col b and its count result in col E and F, respectively. For example, based on the cell values of "ACA1196" in col A, the values "A320" and "A333" would be put in col E and "5" and "1" in col F. SImilarly, for "ACA844", "A333" and "A343" would placed in col E and "1" and "1" in col F. This could be done till the end of the data which is approximately 2500 entries and there is a header for the data. Thanks for your help, Ty Col A Col B ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A333 ACA844 A333 ACA844 A343 ACA850 A333 ACA850 C208 ACA850 A333 ACA850 B763 ACA850 B763 ACA850 C208 ACA850 B763 ACA850 B763 ACA850 A333 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Loop to Count Copy
It works fine for the first two groups, but the third is scattered in column
B. Can it be sorted? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ty" wrote in message ups.com... I have two columns of data- I would like to count the number of entries in col B based on col A, put the cell value for col b and its count result in col E and F, respectively. For example, based on the cell values of "ACA1196" in col A, the values "A320" and "A333" would be put in col E and "5" and "1" in col F. SImilarly, for "ACA844", "A333" and "A343" would placed in col E and "1" and "1" in col F. This could be done till the end of the data which is approximately 2500 entries and there is a header for the data. Thanks for your help, Ty Col A Col B ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A333 ACA844 A333 ACA844 A343 ACA850 A333 ACA850 C208 ACA850 A333 ACA850 B763 ACA850 B763 ACA850 C208 ACA850 B763 ACA850 B763 ACA850 A333 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Loop to Count Copy
What would be ideal is the following,
Col A Col B Col E Col F ACA1196 A320 A320 5 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A333 ACA844 A333 A333 1 ACA844 A343 A343 1 ACA850 A333 A333 3 ACA850 C208 B763 4 ACA850 A333 C208 2 ACA850 B763 ACA850 B763 ACA850 C208 ACA850 B763 ACA850 B763 ACA850 A333 Thanks, Ty On Apr 18, 2:17 am, "Bob Phillips" wrote: It works fine for the first two groups, but the third is scattered in column B. Can it be sorted? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ty" wrote in message ups.com... I have two columns of data- I would like to count the number of entries in col B based on col A, put the cell value for col b and its count result in col E and F, respectively. For example, based on the cell values of "ACA1196" in col A, the values "A320" and "A333" would be put in col E and "5" and "1" in col F. SImilarly, for "ACA844", "A333" and "A343" would placed in col E and "1" and "1" in col F. This could be done till the end of the data which is approximately 2500 entries and there is a header for the data. Thanks for your help, Ty Col A Col B ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A320 ACA1196 A333 ACA844 A333 ACA844 A343 ACA850 A333 ACA850 C208 ACA850 A333 ACA850 B763 ACA850 B763 ACA850 C208 ACA850 B763 ACA850 B763 ACA850 A333- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Macro Copy Active Cell to Range Name, loop | Excel Programming | |||
Macro Copy Active Cell to Range Name, loop | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
a macro to count coloured values and copy.... | Excel Programming | |||
End loop macro with count | Excel Programming |