Excel 2003 formula

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

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
 
=if(count(a:a)=0,"<2",max(a:a))
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
Click to expand...
 
Back
Top