| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count the frequency that a number is repeated?
I have a very large file, with repeated IP addresses in the same column. I
need to know how many times the same Ip address is repeated... like 120.21.18.2 - repeated 630 times 156.44.90.5 - repeated 1023 times appreciate any help - |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the frequency that a number is repeated?
One thought. Use a pivot table. Follow the wizard. In step 3, click Layout,
then just drag the col label for IP addresses into both the ROW and DATA areas. Finish up. The pivot results will return both a unique list of IPs and the counts for each. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "arnie b" <arnie wrote in message ... I have a very large file, with repeated IP addresses in the same column. I need to know how many times the same Ip address is repeated... like 120.21.18.2 - repeated 630 times 156.44.90.5 - repeated 1023 times appreciate any help - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count maximum number of lines repeated for a site | Excel Worksheet Functions | |||
| How can I count numbers without including the repeated values? | Excel Discussion (Misc queries) | |||
| How do I count the frequency of a given number in a column? | New Users to Excel | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
Linear Mode
