How to solve this problem in Excel

Closed
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 2, 2009 at 05:14 AM
pro-genius Posts 185 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 - Mar 3, 2009 at 07:23 AM
Hello,
how to check 3 column data together and it has to check the same 3 column and it has to give the result example
ColA-----------ColB-----------------ColC
1)10--------------20-------------------15
2)88--------------40--------------------30
3)20---------------10-------------------10
4)90--------------100------------------90

&
ColD------------ColE-----------------ColF
1)15----------------20-------------------20
2)22-----------------25-------------------15
3)92-----------------110--------------------90
4)88-----------------40---------------------60
5)88-----------------40---------------------10

Answer has to be like this
1)10-------------20---------------------15 15-------------20-----------20
2)88-------------40---------------------30 88-------------40------------60
this example is ok
Pls tell me how to solve this in Excel & what is the Formula i can use
thanx
Jai
2)

2 responses

sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 31
Mar 2, 2009 at 08:31 AM
I think you have to change the alignment of the cell and reformat them. But i don't know which options to choose!
pro-genius Posts 185 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 68
Mar 3, 2009 at 07:23 AM