Hi Amit,
it's not possible to put unique value in pivot table. u need to create
extra column.
*Team Excel*
On Sun, Jan 8, 2012 at 11:10 PM, Mahesh parab wrote:
> Hi Amit
>
> find attach workbook. hope this will help
> Add one column in your pivot table data & use below formula
> Assuming you w
[mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kris
> *Sent:* Jan/Tue/2012 06:45
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Unique count in Pivot table
>
> ** **
>
> Hi,
>
> ** **
>
> In K14 and copied down,
>
&
HI Krishna,
Output is required within Pivot table as a calculated field I think.
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Jan/Tue/2012 06:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unique count in Pivot
Hi,
In K14 and copied down,
=SUM(IF(FREQUENCY(IF($B$2:$B$13=H14,IF($C$2:$C$13<>"",MATCH($B$2:$B$13&$C$2:$C$13,$B$2:$B$13&$C$2:$C$13,0))),ROW($B$2:$B$13)-ROW($B$2)+1),1))
It's an array formula. Confirmed with CTRL + SHIFT + ENTER.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
: $$Excel-Macros$$ Unique count in Pivot table
Hi Amit
See the attached file..
Please Revert if it not desired
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: Jan/Sun/2012 02:15
To: excel-macros@googlegroups.com
Subject
Hi Amit
See the attached file..
Please Revert if it not desired
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Jan/Sun/2012 02:15
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Unique count in Pivot table
Hi Amit
find attach workbook. hope this will help
Add one column in your pivot table data & use below formula
Assuming you want to count unique values from Range A:A in pivot table
=1/COUNTIF(A:A,A2)
it would be great if you could attach sample workbook.
HTH
Mahesh
On Sun, Jan 8, 2012 at 2:14 P
