Hi There,

i have two columns, strategy, month and third is desired output

STRATEGY month desired output
cta jan 2
cta jan 2
cta feb 1
short feb 1
credit mar 1
long mar 1
event apr 2
event apr 2
short may 1
fixed may 1
long may 1
event june 1


i want to write a macro that groups strategy(column 1) by month(column2) abd
prints in desired output(column 3) . is this poosible as tried to do it by
comparing array , but didnt scucced