View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
markag
 
Posts: n/a
Default maximum repeated value

I'm trying to create an excel formula to give me the maximum repeaded
value in a range of numbers.
example:
5 I need to know the maximum value that occurs more
then once.
5 In this case the number would be 8.
8 Would I be able to write a formula that can do
this, it really
5 would help me out.
1
9
8