Counting Array element
Does it need to be a macro?
=SUMPRODUCT(--($A$2:$A$13&$B$2:$B$13=$A2&$B2))
wi
"asingh" <u59311@uwe wrote in message news:a66bdd1e0c55a@uwe...
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
|