Hello,
I was wondering if there is a way to find the maximum value in a column that is less than the current field?
Hi @nmccarthy82 I mocked up a workflow that should give you the output you described.
@nmccarthy82 - you can use a Summarize tool to find the max of that column and Append Max_column to the rest of the data to use as a Filter.
I think my question might not have been clear. I don't need the absolute maximum value of the column I need to find the value that is less than the a cell.