View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler M.A.Tyler is offline
external usenet poster
 
Posts: 100
Default Criteria governing "LARGE" function

I have a column of numbers, and would like to find the "largest number".
However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)),
I've tried several different things, but nothing really works.

Thanks in advance!

Mike.