• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unique / Distinct list and number of times each number appears

imstein

New Member
I would like someone's help in creating a formula and instructions for the following. I have a list of phone numbers and would like a formula that would help me
1. Create a unique list of the phone numbers that appear and how many times that number appears on the list.
2. Remove the blank lines.
3. Put the answer in one column (the numbers currently appear in two different columns)

Thanks in advance.

Iris
 

Attachments

  • sample numbers.xlsx
    161.3 KB · Views: 0
Hi Iris,

I think you need a couple of preparation steps to get what you want. Please see attached to have a look how I did this.

I make use of a helper column in your data sheet and use this helper column in the PivotTable to get the unique list of phone numbers.
 

Attachments

  • sample numbers.xlsx
    357.7 KB · Views: 1
Back
Top