ExcelBanter - What number appears the most?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What number appears the most? (https://www.excelbanter.com/excel-discussion-misc-queries/219612-what-number-appears-most.html)

[email protected]

What number appears the most?

I want to display what number appears in the same row the most with
the number 1.
So this example, would be 2 as it appears with 1 in the same row 3
times.

4 1 3 2
2 1
4 3 2
1
2 3 4 1

Can anybody help me with this?

curlydave

What number appears the most?

The mode function should work
=MODE(A1:B8)

T. Valko

What number appears the most?

How many times are you going to post this question?

--
Biff
Microsoft Excel MVP

wrote in message
...
I want to display what number appears in the same row the most with
the number 1.
So this example, would be 2 as it appears with 1 in the same row 3
times.

4 1 3 2
2 1
4 3 2
1
2 3 4 1

Can anybody help me with this?

[email protected]

What number appears the most?

On 7 Feb, 21:09, CurlyDave wrote:
The mode function should work
=MODE(A1:B8)

Thank you, MODE is definately the right function, however I think I
need to incorporate IF also, but not sure how.

Using the below example, I would want to find out what appears the
most (MODE) with the number 1 in the same row (IF). The answer is (2)
as it appears with 1 in the same row twice. I'm not sure how to put
this all together though!

4 1 3 2
2 1
4 3 2
1
2 3 4 1

All times are GMT +1. The time now is 04:34 PM.