Repeated Values in a Spread sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi..
I have a captured csv file of a telephone bill.
I would like to filter the data as follows,
The numbers called must be grouped together.
the most dialled numbers must be at the top (or bottom) of the sheet- maybe
indicating the number of times it was dialed (occurance)

Thanx
 
Sorry about the multiple postings above - Google Groups has been
playing up recently and for each of the above it told me there had
been an error when I sent the response. I gave up in the end, but
obviously the message did get through four times.

Pete
 
Say your data is in column A like:

123-456-7890
123-456-7890
456-123-7890
123-456-7890
456-123-7890
123-456-7890
456-123-7890
789-543-4865
123-456-7890
456-123-7890
123-456-7890
123-456-7890
123-456-7890
456-123-7890
456-123-7890
789-543-4865
789-543-4865
123-456-7890
123-456-7890

In B1 enter:

=COUNTIF($A$1:$A$19,A1) and copy down

You should see:

123-456-7890 10
123-456-7890 10
456-123-7890 6
123-456-7890 10
456-123-7890 6
123-456-7890 10
456-123-7890 6
789-543-4865 3
123-456-7890 10
456-123-7890 6
123-456-7890 10
123-456-7890 10
123-456-7890 10
456-123-7890 6
456-123-7890 6
789-543-4865 3
789-543-4865 3
123-456-7890 10
123-456-7890 10

Now sort cols A & B by B Descending and A to see:


123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
123-456-7890 10
456-123-7890 6
456-123-7890 6
456-123-7890 6
456-123-7890 6
456-123-7890 6
456-123-7890 6
789-543-4865 3
789-543-4865 3
789-543-4865 3
 
Back
Top