| 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 |
| 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 | |||
Threaded Mode
