Excel 2003 formula

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
 
D

Dave Peterson

=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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Consolidation Table from Different Excel Tabs with Different Format 1
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Index/Match Functions to Return Concatenated Response 4
Paragraph numbering in Word 1

Top