LittleNick
Technical User
Hi everyone,
I have a table with 4 columns, namely customer,price1, price2, price3. how can I find the maximum price for each custom. Here is an example of my table:
Customer price1 price2 price3
john $3.00 $2.00 $1.00
john $6.00 $3.00 $4.00
Mary $2.00 $5.00 $3.00
The result desired is John $6.00 and Mary is $5.00
Thanks for helps
I have a table with 4 columns, namely customer,price1, price2, price3. how can I find the maximum price for each custom. Here is an example of my table:
Customer price1 price2 price3
john $3.00 $2.00 $1.00
john $6.00 $3.00 $4.00
Mary $2.00 $5.00 $3.00
The result desired is John $6.00 and Mary is $5.00
Thanks for helps