In Sheet3,
With cols A and B populated as before ..
List in C1 across the uniques from col B in Sheet1, ie: h, Y
Then place in C2:
=IF($B2="","",SUMPRODUCT((Sheet1!$A$2:$A$100=$B2)* (Sheet1!$B$2:$B$100=C$1)))
Copy C2 across/fill down. Adapt the ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sandeep Singh" wrote:
Hey Max,

Thanks alot,

I need a little more help,
How can i use your formula with COUNTIF in place of SUMIF?
Instead of Summing up the elements i simply want to count them?

Rest all things remain as earlier, i.e. data in sheet1, formula in sheet3 etc.

Eg: for col A & B
A B
sa h
sa h
sa y
ba y
baba h
sa y

Result:
The result in sheet3 should be
Count_of_h Count_of_Y
sa 2 2
ba 0 1
baba 1 0


Kindly do help me
Thanks again,

Regards,
Sandeep