Two approaches:

1. Autofilter - this can isolate variable one a a time or combined.
2. Pivot table - this can summarize data by catagory

See:
http://www.contextures.com/xlautofilter01.html
and
http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Gary's Student
gsnu200702


"luiss" wrote:

Hi,

I have a table with formulae, and several variables (the main variable being
number of persons, which varies between 6 and 84; other variables - client
type, commission, duration of service, number of crew, have 2 values each),
and I would like to make a table based on the number of persons, for each of
this variables.

Can someone assist me?

Thanks

Luis Serpa