count of duplicates

[#1]

Hi Folks, I need to count the overlap values (duplicates) for a key id value. I have the data like below:

AreaName , KEYID

ABC , 1

ABC , 2

ABC , 3

ABC , 4

ABC , 5

ABC , 6

XYZ , 1

XYZ , 2

XYZ , 7

XYZ , 11

PQR , 1

PQR , 12

PQR , 10

PQR , 11

I need the following table:

ABC , 3

XYZ , 3

PQR , 2

[#2]

Could you please explain briefly?

[giakoum]

ABC , 6

XYZ , 3

PQR , 4

if this is what you mean, where do you need it to be done? In script or chart? Otherwise you need to explain in more detail.

[its_anandrjs]

Your requirement is not clear and sample data is also not clear. provide more sample.

Thanks & Regards

[its_anandrjs]

Use Count( AreaName ) will give you result

Hope this helps

[maxgro]

ABC , 3          duplicated 1, 2 and ???  why 3, I think 2

XYZ , 3          duplicated  1, 2, 11

PQR , 2          duplicated  1, 11

RESULT