Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

How to do the Union of two columns in MS EXcel?

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
I want to do a union of two columns in Excel by using some function. for eg one column has nos like 0,1,2 and the other has fields passed and failed.I want to count the no of 0s along with passed and 0s with failed and the rest.I have tried the and function but in vail.Please do tell me how to do the union of the two columns in Excel itself.
  • 0





  • Member
  • PipPip
  • 98 posts
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
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.


Attached Files

  • 0




  • Member
  • PipPip
  • 18 posts
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

Edited by jasonharrod, 13 July 2005 - 09:20 AM.

  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP