Re: Count and display number of items
From: Earl Kiosterud (nowhere_at_nowhere.com)
Date: 06/25/04
- Next message: Mark Cain: "convert hh:mm:ss to decimal"
- Previous message: monty: "Invoice Template"
- In reply to: Andy: "Count and display number of items"
- Next in thread: Andy: "Re: Count and display number of items"
- Reply: Andy: "Re: Count and display number of items"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Jun 2004 15:08:36 -0400
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: Mark Cain: "convert hh:mm:ss to decimal"
- Previous message: monty: "Invoice Template"
- In reply to: Andy: "Count and display number of items"
- Next in thread: Andy: "Re: Count and display number of items"
- Reply: Andy: "Re: Count and display number of items"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
