max function for less than or greater than values

[rubama92]

Hello,

I am dealing with a concentration dataset where there are < or > symbols involved in the dataset. The max formula with implicit is not working for me. Thoughts for resolution?

[#2]

@rubama92 

It depends on how you want to treat a value such as ">100". If you want to count that as 100, you could do the following.

Let's say the data are in A2:A100.

=MAX(--SUBSTITUTE(SUBSTITUTE(A2:A100, ">", ""), "<", ""))

If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.