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.
