Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping inside a macro
dear everyone,
I have 3 columns say colA colB Col C row1 1 A pen row2 2 B sit row3 1 A read now i want my output to be like colA colB Col C row1 1 A pen row2 read row3 2 B sit that is i want to group all the As in the column B and allow it to display only once for howmany ever rows we have in col C. The main thing is that these rows get filled from another sheet. therefore they are dynamic, i may have any number of rows in this sheet. I want to do this kind of grouping inside a macro. kindly help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Input box inside a macro | Excel Discussion (Misc queries) | |||
HELP NEEDED FOR IF Function Inside a Macro | Excel Worksheet Functions | |||
Macro Inside Cell | Excel Discussion (Misc queries) |