Thanks
How to do the Union of two columns in MS EXcel?
Started by
bhav
, Jul 13 2005 03:54 AM
#1
Posted 13 July 2005 - 03:54 AM
Thanks
#2
Posted 13 July 2005 - 05:03 AM
The first part of your question is how to combine columns.
If Cell A1 = "0", B1 = "Passed", C1 = "=A1&B1"
Then C1 will display "0Passed"
By copying the formula in C1 down you can combine the columns.
The second part of your question referred to counting the results.
You do not need to combine the columns to do this.
A much more effective way is to use a pivot table.
The result of a pivot table will look something like
NUM 0 1 2
STATUS
Passed 4 22 9
Failed 11 8 16
The following link has some more info on pivot tables.
http://www.exceltip....Report/283.html
I have also attached a sample file.
If you right click anywhere in the pivot table results and select wizard you will be able to step back and forth through the Pivot options.
Regards
David
If Cell A1 = "0", B1 = "Passed", C1 = "=A1&B1"
Then C1 will display "0Passed"
By copying the formula in C1 down you can combine the columns.
The second part of your question referred to counting the results.
You do not need to combine the columns to do this.
A much more effective way is to use a pivot table.
The result of a pivot table will look something like
NUM 0 1 2
STATUS
Passed 4 22 9
Failed 11 8 16
The following link has some more info on pivot tables.
http://www.exceltip....Report/283.html
I have also attached a sample file.
If you right click anywhere in the pivot table results and select wizard you will be able to step back and forth through the Pivot options.
Regards
David
Attached Files
#3
Posted 13 July 2005 - 09:18 AM
I'm not really sure of what you are trying to do, here is what I came up with
just do a Append on the columns you need and then do a countif(range,"Criteria")
then do a Counta(range)-the 0failed countif(range,criteria) - 0Passed countif(range,"Criteria") to get everything else.
Hope that helped
just do a Append on the columns you need and then do a countif(range,"Criteria")
then do a Counta(range)-the 0failed countif(range,criteria) - 0Passed countif(range,"Criteria") to get everything else.
Hope that helped
Edited by jasonharrod, 13 July 2005 - 09:20 AM.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users