| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What number appears the most?
The mode function should work
=MODE(A1:B8) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the times a number appears | Excel Discussion (Misc queries) | |||
| find the frequency a number appears with another number within a s | Excel Worksheet Functions | |||
| Selecting the first time a number appears | Excel Discussion (Misc queries) | |||
| same number appears in a random number generator | Excel Worksheet Functions | |||
| The number I type in a cell, e.g. 500, appears at 0.5 - why? | Excel Discussion (Misc queries) | |||
Linear Mode
