I am trying to condense some large data sets by finding the maximum value in a range of data that contains both numbers and text.
In my example I'd like the highlighted cell to show the highest numerical value if one exists (4 in this case), if there's none of these then show the value of the highest 'less than' (<2 here) or if there's neither of these then just return a dash.
I'm having a bit of trouble wrapping my head around this one, can anyone think of a way to get this to work?
thanks
In my example I'd like the highlighted cell to show the highest numerical value if one exists (4 in this case), if there's none of these then show the value of the highest 'less than' (<2 here) or if there's neither of these then just return a dash.
I'm having a bit of trouble wrapping my head around this one, can anyone think of a way to get this to work?
thanks