| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate the mode of a column of IP addresses?
In article ,
says... Thanks, all, for the helpful information. I was able to get it to work, though will need to put it elsewhere and then finesse it for my summaries. I must say, when what I want to do is show the most-common string, and the 2nd-most-common, and so on ... that's a lot of hoops to jump through! Not sure why a PivotTable would be "lots of hoops to jump through." All you would do is select Top {n} where n is a number you provide. Same effort for Top 1 as for Top 10. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Threaded Mode
