Identify and list Minimum Value

[amtbew]

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

[Ahmedx]

pls try this

[amtbew]

@Ahmedx thanks for the reply. If I include the Vendor name in the table, then it shows the products multiple times. 

How do I go about acheiving this result?

Product	Vendor	Cost
ID1	Joe	10
ID2	Joe	5
ID3	Jane	10

[Ahmedx · Accepted solution]

pls try