Finding mode of 3-digit integer in multi-digit array

[sdchris]

I'm trying to write a formula that will calculate the mode (most frequently used #) in a data set for all 3-digit numbers. There are also 1- 2- and 4-digit numbers in the set. Here's an example below:

101
1235
100
759
101
2
1235
5
1235

In this case, the mode for 3-digit numbers would be 101, since it is the only 3-digit number that occurs more than once.

Any advice would be great. Thanks.

 

[Rick Rothstein]

I'm trying to write a formula that will calculate the mode (most frequently used #) in a data set for all 3-digit numbers. There are also 1- 2- and 4-digit numbers in the set. Here's an example below:

101
1235
100
759
101
2
1235
5
1235

In this case, the mode for 3-digit numbers would be 101, since it is the only 3-digit number that occurs more than once.

Any advice would be great. Thanks.

You can use this array-entered** formula (just adjust the two ranges to cover your numbers)...

=MODE(IF(LEN(A1:A9)=3,A1:A9))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself.