Forum Discussion
Solved
Identify and list Minimum Value
Here's some sample data.
| Product | Vendor Name | Cost |
| ID1 | Joe | 10 |
| ID1 | John | 15 |
| ID2 | Joe | 5 |
| ID3 | Jane | 10 |
| ID3 | Joe | 15 |
I'd like to find the minimum value in the Cost Column for each distinct Product.
This is the result I'd like to be able to see.
| Product | Vendor | Cost |
| ID1 | Joe | 10 |
| ID2 | Joe | 5 |
| ID3 | Jane | 10 |
The next step would be summing the lowest cost to see the total cost for all 3 products.
Thanks
pls try
