| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeating Number
Can I have excel return the number that repeats itself the most whithin a
cell range? A colum for exemple |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeating Number
Use the =MODE() function, for example:
=MODE(A1:A10) -- Gary''s Student - gsnu200735 "Sly" wrote: Can I have excel return the number that repeats itself the most whithin a cell range? A colum for exemple |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a random Colum 1-55 without repeating a number | Excel Discussion (Misc queries) | |||
| How do I check repeating sets of number in a range | Excel Worksheet Functions | |||
| random number without repeating? | Excel Worksheet Functions | |||
| Random Number Non Repeating ... | Excel Discussion (Misc queries) | |||
| Repeating number sequence in a column | Excel Discussion (Misc queries) | |||
Linear Mode
