Thread: Repeating Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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 With QuoteReply With Quote