 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Repeated Values in a Spread sheet
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  Signature!ngeniuos (99% Perspiration) You should obtain a unique list of numbers dialled on a separate sheet using Advanced Filter, then you can use a COUNTIF formula to count how many calls are made to each of those numbers, then sort this in descending order. Hope this helps. Pete On May 23, 9:40 am, !ngeniuos <ngeni...@discussions.microsoft.com> wrote: > Hi.. > I have a captured csv file of a telephone bill. [quoted text clipped - 7 lines] > !ngeniuos > (99% Perspiration) You should obtain a unique list of numbers dialled on a separate sheet using Advanced Filter, then you can use a COUNTIF formula to count how many calls are made to each of those numbers, then sort this in descending order. This will give you the most frequently dialled numbers. Hope this helps. Pete On May 23, 9:40 am, !ngeniuos <ngeni...@discussions.microsoft.com> wrote: > Hi.. > I have a captured csv file of a telephone bill. [quoted text clipped - 7 lines] > !ngeniuos > (99% Perspiration) You should obtain a unique list of numbers dialled on a separate sheet using Advanced Filter, then you can use a COUNTIF formula to count how many calls are made to each of those numbers, then sort this in descending order. This will give you the most frequently dialled numbers. Hope this helps. Pete On May 23, 9:40 am, !ngeniuos <ngeni...@discussions.microsoft.com> wrote: > Hi.. > I have a captured csv file of a telephone bill. [quoted text clipped - 7 lines] > !ngeniuos > (99% Perspiration) You should obtain a unique list of numbers dialled on a separate sheet using Advanced Filter, then you can use a COUNTIF formula to count how many calls are made to each of those numbers, then sort this in descending order. This will give you the most frequently dialled numbers. Hope this helps. Pete On May 23, 9:40 am, !ngeniuos <ngeni...@discussions.microsoft.com> wrote: > Hi.. > I have a captured csv file of a telephone bill. [quoted text clipped - 7 lines] > !ngeniuos > (99% Perspiration) 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 > You should obtain a unique list of numbers dialled on a separate sheet > using Advanced Filter, then you can use a COUNTIF formula to count how [quoted text clipped - 23 lines] > > - Show quoted text - 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 SignatureGary''s Student - gsnu200731
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.