| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bimodal data
Hi
If a set of data has two modes, eg 3,3,3,6,6,6 then the MODE worksheet function will only report the smallest one as being the mode. Is there some sort of work around in VBA which will allow me to report both modes ? TIA Andrew B |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Bimodal data
In VBA,
You can write your own function to find all candidate modes and report them. You might use the frequency function to discover multiple modes. -- Regards, Tom Ogilvy "Andrew B" wrote in message ... Hi If a set of data has two modes, eg 3,3,3,6,6,6 then the MODE worksheet function will only report the smallest one as being the mode. Is there some sort of work around in VBA which will allow me to report both modes ? TIA Andrew B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
| Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
| Bimodal histograms | Charts and Charting in Excel | |||
![Andrew B[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
