Count Function
Try using PivotTables for this--no formulas required.
Elisabeth
"Uma Nandan" wrote:
Hi
Can someone help me...
Eg: Raw Data
A B
1 uma Pen
2 uma Pen
3 uma Pen
4 sundu tamang Pen
5 sundu tamang Pen
6 sundu tamang Pen
7 sundu tamang Pen
8 uma pencil
9 uma pencil
10 sundu tamang Rubber
11 sundu tamang Rubber
I need the count to be displayes as mentioned below for the above data:
the formula should check column A and then take the count for relvant
product from column B.
Currently iam doing it manually and can some one help me with it cause now i
have huge data of 10k for which i need to check the count as mentioned below.
Eg: Output should be
A B C D
1 Name Pen Pencil Rubber
2 Uma 3 2 0
3 Sundu Tamang 4 2 2
thnaks in advance.
|