Re: Count and display number of items

From: Andy (wiltshireguyuk_at_yahoo.co.uk)
Date: 06/26/04

  • Next message: Peo Sjoblom: "Re: Count and display number of items" 
    Date: 26 Jun 2004 08:09:55 -0700

    Earl,

    Thank you! I'm kind of new to Excel formulas but since you pointed me
    in the right direction I got the chart I wanted after a few attempts.

    One more thing - I have a second work***, names in one column and
    there phone number in the next. Is there any way I can link the names
    to the numbers so the names are shown in the pivot table rather than
    the numbers?

    Thanks in advance.

    Andy.

    "Earl Kiosterud" <nowhere@nowhere.com> wrote in message news:<ev5nSfuWEHA.3472@TK2MSFTNGP09.phx.gbl>...
    > Andy,
    >
    > A pivot table can do just that. Set the data function to COUNT, if not
    > already.
    >
    > To identify the duplicates, you can sort your table on the telephone number
    > column, and put in a helper column:
    >
    > =if(A3=A2, "Dup","")
    >
    > Copy down.
    >
    > --
    > Earl Kiosterud
    > mvpearl omitthisword at verizon period net
    > -------------------------------------------
    >
    > "Andy" <wiltshireguyuk@yahoo.co.uk> wrote in message
    > news:a9320de.0406251053.1a176004@posting.google.com...
    > > Hi there,
    > >
    > > I have one column of telephone numbers, please can someone help me
    > > with a formula to create another column showing how many occurrences
    > > there are of each number. Thanks!
    > >
    > > Andy.

  • Next message: Peo Sjoblom: "Re: Count and display number of items"