Lookup Min/Max

thanks Greg,

my table looks like this,  so there are multiple repeating scenario ids, and for example COP-0001 will have step numbers 1-35, i basically need to return the lowest, which should be 1 and the highest, 35, and access those date records.

Im trying your code, but not sure about the __Table and ___Value parts/

Could you paste an example code following your pattern

Business Unit          Stream                        Scenario ID                         Step Number        Planned Date                       Execution Date