This content has been marked as final. Show 4 replies
I want to find the lowest value of "Time" for a given Incident number, where "New Value" starts with "A" and put it into a new variable in the example below. The number of rows per incident varies.
I have tried RangeMin, but can't make it work... Any suggestions?
|Incident number||New value||Time|
|Incident number||Lowest value, A*|