# Calculating number of times individual number appears in a pivot table

1. ## Calculating number of times individual number appears in a pivot table

I have a excel document with several different numbers in column A, when i pivot the data and 'Count' this value it totals these values. I want it to only show this figure once

e.g
 Number Name 123 Joe 123 Joe 234 Mark 234 Mark 234 Mark 999 Jackie 567 Anne

So i want to pivot table to show

Joe - 1
Mark - 1
Jackie - 1
Anne - 1

At the moment its showing

Joe - 2
Mark - 3
Jackie - 1
Anne - 1

Can any body help me???

2. ## Re: Calculating

see attached file

3. ## Re: Calculating

Put the name into the data section,

then double click

now change to choose Count

that will count as you have it now - so 2 etc for each name
to get to a unique value

then use the TAB
show values as
and select the last one
index

5. ## Re: Calculating number of times individual number appears in a pivot table

Sorry for the short title, i forgot to go back and amend it before clicking submit

Although they have been helpful, still not quite what i'm after, ive thought about it and is there a formula that can work out work out how many times the number appears and divide it by one. so you will get a table like

Number Decimal Name
123 0.5 Joe
123 0.5 Joe
234 0.33 Mark
234 0.33 Mark
234 0.33 Mark
999 1 Jackie
567 1 Anne

So when the pivot it done it will total 1?

6. ## Re: Calculating number of times individual number appears in a pivot table

Sorry for the short title, i forgot to go back and amend it before clicking submit

Although they have been helpful, still not quite what i'm after, ive thought about it and is there a formula that can work out work out how many times the number appears and divide it by one. so you will get a table like

Number Decimal Name
123 0.5 Joe
123 0.5 Joe
234 0.33 Mark
234 0.33 Mark
234 0.33 Mark
999 1 Jackie
567 1 Anne

So when the pivot it done it will total 1?

7. ## Re: Calculating number of times individual number appears in a pivot table

see the attached file

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1