..:: Please solve this ::..

sure sounds like homework

--
Don Guillett
SalesAid Software
[email protected]
"dealoflove" <[email protected]> wrote
in message news:[email protected]...
>
> I have data in the following format with coloumn A and B
>
> Age Status
> 1 2
> 2 1
> 2 2
> 1 1
> 1 1
> 2 3
> 1 1
> 1 1
> 2 3
> 1 2
>
>
> There are two variables or coloumn names age and status then
>
> if age = 1 that implies 18-25
> if age = 2 that implies 25-30
>
> whereas if status = 1 that implies unmarried
> if status = 2 that means married
> if status = 3 that means divorced
>
> this is a qulalitative data
>
> I want to get following table
>
> [/html]
> Age married unmarried divorced Total
>
> 18-25 2 4 0 6
>
> 25-30 1 1 2 4
>
> Total 3 5 2 10[/HTML]
>
> Any method, any formula, software which is helpful please tell me that
> its very urgent for me as i have to do number of such cross coloumn
> analysis. please support your answer with an example.
>
>
> --
> dealoflove
> ------------------------------------------------------------------------
> dealoflove's Profile:
> http://www.excelforum.com/member.php...o&userid=32780
> View this thread: http://www.excelforum.com/showthread...hreadid=526142
>

dealoflove -

Use a pivot table.

- Mike
www.mikemiddleton.com

"dealoflove" <[email protected]> wrote
in message news:[email protected]...
>
> I have data in the following format with coloumn A and B
>
> Age Status
> 1 2
> 2 1
> 2 2
> 1 1
> 1 1
> 2 3
> 1 1
> 1 1
> 2 3
> 1 2
>
> There are two variables or coloumn names age and status then
>
> if age = 1 that implies 18-25
> if age = 2 that implies 25-30
>
> whereas if status = 1 that implies unmarried
> if status = 2 that means married
> if status = 3 that means divorced
>
> this is a qulalitative data
>
> I want to get following table
>
> [/html]
> Age married unmarried divorced Total
>
> 18-25 2 4 0 6
>
> 25-30 1 1 2 4
>
> Total 3 5 2 10[/HTML]
>
> Any method, any formula, software which is helpful please tell me that
> its very urgent for me as i have to do number of such cross coloumn
> analysis. please support your answer with an example.
>
> --
> dealoflove

please explain this or tell me any other tool tosolve this

dealoflove -

> please explain this or tell me any other tool to solve this <

If you want an explanation of how to use a pivot table for your task, browse
to www.google.com and search for "excel pivot table tutorial" (without the
quotes).

- Mike
www.mikemiddleton.com