Min or Max of two columns in table

[raghavsurya]

Hi All,

I have a requirement wherein I need to pick Min or Max of two tables Sales, services.  Below is a small example provided.

City	Sales	Services
London	100	50
Paris		60
Zurich	200

I need to pick Min value of Sales and Services together in one expression which is 50.

Can anybody suggest how to get it done.

Regards,

Raghav

[swuehl · Accepted solution]

Try

=RangeMin(Min(Sales),Min(Services))

[CELAMBARASAN]

Hi,

     Use Range functions for multiple columns.

     RangeMin(Min(Sales),Min(Services))

     RangeMax(Max(Sales),Max(Services))

Celambarasan