Count unique value in pivot table

**minkus** · 11-24-2010, 03:31 PM

Hello,

I'm working with data for call volume that is pulled weekly where each call has a unique ID (text value, ie 2-1005-01) -- and I'm running in to problems where if a call isn't recieved by one controller it uses the same ID and gets rolled to the next available controller, but shows as two line items -- I'd like to be able to count the number of unique call IDs by week.

Any thoughts/ideas are greatly appreciated!

Thank you

**KiPA** · 11-24-2010, 04:50 PM

This should do it: http://www.excelforum.com/excel-work...in-counts.html

**lazyvba** · 11-25-2010, 06:20 AM

Hello,
this code should allow you to use the unique count as a data field, letting you see the result by week or other indicators.
I'm using it but would like to know if it's working for others. It's juste code to paste once.
http://lazyvba.blogspot.com/2010/11/...-to-count.html

let me know and have a good day

**minkus** · 11-29-2010, 02:48 PM

I ended up creating a column using IF(COUNTIF($B$2:B2,B2)=1,1,0) and dragging it the length

It looks like the formula you pointed me to KiPA would work just the same -- and I'm just checking out your site now lazyvba -- I'll have to get back to you on trying it out.

Thanks for your help!