How to do the Union of two columns in MS EXcel?
Posted 13 July 2005 - 03:54 AM
Posted 13 July 2005 - 05:03 AM
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
Passed 4 22 9
Failed 11 8 16
The following link has some more info on pivot tables.
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.
Posted 13 July 2005 - 09:18 AM
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.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users