"Khally" wrote:
I did not understand which branch. please advise

Here's what I posted over there ..
-----
"Khally" wrote:
Both the options are not working for me.

Then it could be a data consistency issue between what you actually have in
the source sheet: Data (in the "Stock#" col and/or in the "Month" col), and
what you have set up as the col / row headers in the other "summary" sheet.
If the data isn't consistent, then the SP formula as earlier suggested won't
work properly.

Anyway, here's a quick working sample for the earlier SP suggestion:
http://cjoint.com/?iomo3rW0Zs
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---