i need to know how i can give out the max/min from a column.
example
Product
Cost
A
100
B
200
C
300
D
400
E
500
If i choose product D it should compare the Cost of product D (400) with the other product's cost and finaly give out the minimum cost which is 100. something like this:
if Product D = 400 -> compare cost with other products -> give out min cost
could anyone please help me out here?
i know that there s an expression for max/min like max(Cost), but it does not make the comparison which i want to see.
