ExcelBanter - Excel 2003 formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2003 formula (https://www.excelbanter.com/excel-worksheet-functions/192576-excel-2003-formula.html)

Pete

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

Dave Peterson

Excel 2003 formula

=if(count(a:a)=0,"<2",max(a:a))

Pete wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 02:04 PM.