ExcelBanter - Repeating Number

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Repeating Number (https://www.excelbanter.com/excel-worksheet-functions/152120-repeating-number.html)

Sly

Repeating Number

Can I have excel return the number that repeats itself the most whithin a
cell range? A colum for exemple

Gary''s Student

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

All times are GMT +1. The time now is 07:11 PM.