Hi, I've got a table that looks somewhat like this:
Process | Rating | Name | Value |
A | Major | X | 5 |
A | Major | Y | 3 |
B | Minor | Z | 4 |
B | Minor | AB | 2 |
I would like to result in something like this:
Process | Rating | Name | Min_Value |
A | Major | Y | 3 |
B | Minor | AB | 2 |
where the Summarize tool is calculating the Minimum of the Value field, and the Name field is now taking the Name cell that is next to the minimum value(s) in the Value field. I tried Grouping by Name after the Min_Value but that just has as many records as there were before and I want less. How do I do this please? Thanks in advance.
Solved! Go to Solution.
@echuong1's solution is perfect if you only need one row for every process. If two or more rows correspond with the min value then you will want to take the join approach.