View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete Pete is offline
external usenet poster
 
Posts: 193
Default Excel 2003 formula

I have a column of data that I am trying to manipulate, I'm not sure which
formula to use. My column has "<2" in every cell. But if a number, say 5,
appears, it has to select the highest number. Otherwise, it stays at <2