<div>
If you use MODE (or MODE.SNGL in Excel 2010) worksheet function it wouldn't choose any of those - MODE gives you #N/A if there are no duplicate numbers. If 2 or more numbers have the same number of instances it just picks the first instance in the range so if you have<br />
<br />
123<br />
345<br />
123<br />
345<br />
<br />
Excel picks 123<br />
<br />
regards, barry
</div>


If you use MODE (or MODE.SNGL in Excel 2010) worksheet function it wouldn't choose any of those - MODE gives you #N/A if there are no duplicate numbers. If 2 or more numbers have the same number of instances it just picks the first instance in the range so if you have

123
345
123
345

Excel picks 123

regards, barry

<div>
Sorry I didn't make clear. &nbsp;In each row the numbers are separate.<br />
<br />
1,5,4,6,2,2,1 Excel mode is 1<br />
1,2,1,3,2,3 &nbsp; Excel Mode is 1<br />
3,2,3,1,2,1 &nbsp; Excel Mode is 3
</div>


Sorry I didn't make clear.  In each row the numbers are separate.

1,5,4,6,2,2,1 Excel mode is 1
1,2,1,3,2,3   Excel Mode is 1
3,2,3,1,2,1   Excel Mode is 3

<div>
What about the second part of my question? &nbsp;Suppose I have one of the above series in a 1D array. &nbsp;How do I get the same mode as Excel using vb 2008 in asp.net 3.5?
</div>


What about the second part of my question?  Suppose I have one of the above series in a 1D array.  How do I get the same mode as Excel using vb 2008 in asp.net 3.5?

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for AlHal2's comment <a href="https://www.experts-exchange.com/questions/27864817/multiple-mode-values-in-excel.html?anchorAnswerId=38398416#a38398416" rel="ugc">#a38398416</a><br />
<br />
for the following reason:<br />
<br />
Partially answered.
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for AlHal2's comment #a38398416 [https://www.experts-exchange.com/questions/27864817/multiple-mode-values-in-excel.html?anchorAnswerId=38398416#a38398416]

for the following reason:

Partially answered.

<div>
<div class="content wysiwyg-content">
Suppose I have these 3 series of numbers.<br />
1546221<br />
121323<br />
323121<br />
<br />
Which number would the Excel choose as the mode and why?<br />
How can I replicate this methodology in Asp.net 3.5 with VB 2008?
</div>
</div>


Suppose I have these 3 series of numbers.
1546221
121323
323121

Which number would the Excel choose as the mode and why?
How can I replicate this methodology in Asp.net 3.5 with VB 2008?

multiple mode values in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications