Max of a column less then the current field

[nmccarthy82]

Hello,

I was wondering if there is a way to find the maximum value in a column that is less than the current field? 

[JessieC]

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

[nmccarthy82]

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. 

[JessieC]

@nmccarthy82 - do you have a sample data set or can you give an example?

[nmccarthy82]

 For Example I want to look at the number 3 in column B and find out what is the maximum value in column A that is less than the 3 that is in column B. 

[JosephSerpis · Accepted solution]

Hi @nmccarthy82 I mocked up a workflow that should give you the output you described.